> -----Original Message-----
> From: Dave Cramer [mailto:Dave@micro-automation.net] 
> Sent: 12 March 2003 14:55
> To: Dave Page
> Cc: Zeugswetter Andreas SB SD; Hiroshi Inoue; Tom Lane; Bruce 
> Momjian; pgsql-hackers@postgresql.org; pgsql-interfaces@postgresql.org
> Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign
> 
> 
> This may be problematic in the future if we change attrelid, attnum.

I suggested using names to Tom for this reason, but he preferred to use
attrelid/attnum.

> My preference would be to be able to query the backend for 
> the information if I need it. It is rarely required.

Rarely required by most applications, but most interfaces do need this
ability, and so do apps like pgAdmin and OpenOffice that allow the
execution of arbitrary queries and subsequent updating of the results.

Regards, Dave.
Wed, 12 Mar 2003 15:02:23 -0000
"Dave Page" <dpage@vale-housing.co.uk>
Re: Roadmap for FE/BE protocol redesign
On Wed, Mar 12, 2003 at 03:02:23PM -0000, Dave Page wrote:

> > This may be problematic in the future if we change attrelid, attnum.
> 
> I suggested using names to Tom for this reason, but he preferred to use
> attrelid/attnum.

Oh, and what happenned to the attlognum idea?  If something that needs
it is going to be implemented the column should probably be added now
and used instead of attnum.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"In a specialized industrial society, it would be a disaster
to have kids running around loose." (Paul Graham)

Wed, 12 Mar 2003 11:10:20 -0400
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Roadmap for FE/BE protocol redesign
On Wed, 2003-03-12 at 10:02, Dave Page wrote:
> > -----Original Message-----
> > From: Dave Cramer [mailto:Dave@micro-automation.net] 
> > Sent: 12 March 2003 14:55
> > To: Dave Page
> > Cc: Zeugswetter Andreas SB SD; Hiroshi Inoue; Tom Lane; Bruce 
> > Momjian; pgsql-hackers@postgresql.org; pgsql-interfaces@postgresql.org
> > Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign
> > 
> > 
> > This may be problematic in the future if we change attrelid, attnum.
> 
> I suggested using names to Tom for this reason, but he preferred to use
> attrelid/attnum.

Ok, but I am willing to bet that this will be a problem later. However
we can deal with it later, as well.

> 
> > My preference would be to be able to query the backend for 
> > the information if I need it. It is rarely required.
> 
> Rarely required by most applications, but most interfaces do need this
> ability, and so do apps like pgAdmin and OpenOffice that allow the
> execution of arbitrary queries and subsequent updating of the results.

Yes, the interface requires it but how often? If I just do a select *
from foo, I don't need all the metadata, it's only if I do getColumnName
or something that I need metadata.

However qualified column names would be nice, as in the instance when
two column names are the same from different tables.
> 
> Regards, Dave.
-- 
Dave Cramer <dave@fastcrypt.com>
Cramer Consulting


12 Mar 2003 10:14:01 -0500
Dave Cramer <dave@fastcrypt.com>
Re: Roadmap for FE/BE protocol redesign
> > I suggested using names to Tom for this reason, but he preferred to use
> > attrelid/attnum.
>
> Oh, and what happenned to the attlognum idea?  If something that needs
> it is going to be implemented the column should probably be added now
> and used instead of attnum.

Weeeell, it'd be nice, but I can see ways of doing ALTER COLUMN/SET TYPE
without it, so...

(My work on that has been stalled for a while BTW, due to sheer difficulty!)

Chris


Thu, 13 Mar 2003 09:55:30 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: Roadmap for FE/BE protocol redesign
Alvaro Herrera kirjutas K, 12.03.2003 kell 17:10:
> On Wed, Mar 12, 2003 at 03:02:23PM -0000, Dave Page wrote:
> 
> > > This may be problematic in the future if we change attrelid, attnum.
> > 
> > I suggested using names to Tom for this reason, but he preferred to use
> > attrelid/attnum.
> 
> Oh, and what happenned to the attlognum idea?  If something that needs
> it is going to be implemented the column should probably be added now
> and used instead of attnum.

I guess that attlognum is _not_ needed here. The only need for attlognum
would be for automatic column ordering when doing "select * " and 
"\d table", for all other purposes attnum is much more reliable.

-----------------
Hannu


13 Mar 2003 08:54:24 +0200
Hannu Krosing <hannu@tm.ee>
Re: Roadmap for FE/BE protocol redesign