> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp] 
> Sent: 13 March 2003 10:04
> To: Dave Page
> Cc: tgl@sss.pgh.pa.us; ZeugswetterA@spardat.at; 
> pgman@candle.pha.pa.us; pgsql-hackers@postgresql.org; 
> pgsql-interfaces@postgresql.org
> Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign
> 
> 
> Dave Page wrote:
> > 
> > It's rumoured that Hiroshi Inoue once said:
> > >
> > > Does looking up by the catalog keys take no cost ?
> > 
> > Obviously there is cost, but doing a lookup only on demand, 
> has got to 
> > be cheaper in the long run than including the entire column 
> definition 
> > in the message whether it's wanted or not?
> 
> So if there are 100 fields, should we ask the backend 
> the column name 100 times ?

No, the column name is there already. This is useful for additional info
such as uniqueness, nullability, default value, contraints and so on.
Surely you don't want to get the entire relevant bits of the system
catalogues with every query unless we specifically request it?

Regards, Dave.
Thu, 13 Mar 2003 19:20:57 -0000
"Dave Page" <dpage@vale-housing.co.uk>
Re: Roadmap for FE/BE protocol redesign
> -----Original Message-----
> From: Dave Page
> 
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp] 
> > Sent: 13 March 2003 10:04
> > To: Dave Page
> > Cc: tgl@sss.pgh.pa.us; ZeugswetterA@spardat.at; 
> > pgman@candle.pha.pa.us; pgsql-hackers@postgresql.org; 
> > pgsql-interfaces@postgresql.org
> > Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign
> > 
> > 
> > Dave Page wrote:
> > > 
> > > It's rumoured that Hiroshi Inoue once said:
> > > >
> > > > Does looking up by the catalog keys take no cost ?
> > > 
> > > Obviously there is cost, but doing a lookup only on demand, 
> > has got to 
> > > be cheaper in the long run than including the entire column 
> > definition 
> > > in the message whether it's wanted or not?
> > 
> > So if there are 100 fields, should we ask the backend 
> > the column name 100 times ?
> 
> No, the column name is there already. 

The column name isn't there. If a field has its alias name the alias
is there.

regards,
Hiroshi Inoue 


Fri, 14 Mar 2003 06:46:31 +0900
"Hiroshi Inoue" <inoue@tpf.co.jp>
Re: Roadmap for FE/BE protocol redesign
It's rumoured that Hiroshi Inoue once said:
>> -----Original Message-----
>> From: Dave Page
>>
>> > -----Original Message-----
>> > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
>> > Sent: 13 March 2003 10:04
>> > To: Dave Page
>> > Cc: tgl@sss.pgh.pa.us; ZeugswetterA@spardat.at;
>> > pgman@candle.pha.pa.us; pgsql-hackers@postgresql.org;
>> > pgsql-interfaces@postgresql.org
>> > Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign
>> >
>> >
>> > Dave Page wrote:
>> > >
>> > > It's rumoured that Hiroshi Inoue once said:
>> > > >
>> > > > Does looking up by the catalog keys take no cost ?
>> > >
>> > > Obviously there is cost, but doing a lookup only on demand,
>> > has got to
>> > > be cheaper in the long run than including the entire column
>> > definition
>> > > in the message whether it's wanted or not?
>> >
>> > So if there are 100 fields, should we ask the backend
>> > the column name 100 times ?
>>
>> No, the column name is there already.
>
> The column name isn't there. If a field has its alias name the alias is
> there.

Ahh yes, you're right of course. The docs are a little sketchy on that
detail
(http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=protocol-message-formats.html).
Regards, Dave



Fri, 14 Mar 2003 08:47:03 -0000 (GMT)
"Dave Page" <dpage@vale-housing.co.uk>
Re: Roadmap for FE/BE protocol redesign