What is needed, at least from my perspective, is a way to determine proper meta data for a given column. Is it updatable? Is it nullable? Is it part of a primary key or index? Without either the base table name or attrelid,indrelid of the table, I can't get this info.
Reggie > -----Original Message----- > From: Bruce Momjian [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 4:01 PM > To: Peter Eisentraut > Cc: Tom Lane; Reggie Burnett; 'Dave Cramer'; 'PostgreSQL Hackers Mailing > List' > Subject: Re: [HACKERS] Request for qualified column names > > > Dave Cramer says it is needed for the jdbc spec, somehow. It seems kind > of odd so I don't want to make too complex an implementation. > > ------------------------------------------------------------------------ -- > - > > Peter Eisentraut wrote: > > Bruce Momjian writes: > > > > > My idea on this after chat with Dave was to add a GUC option that puts > > > the schema.table.column name as the default column label, rather than > > > just the column name. > > > > Can someone explain why this is needed at all? There is a reason why > the > > SQL standard does not provide for this information: it's not well > defined. > > Are you trying to make up a poor substitute for updatable views? > > > > -- > > Peter Eisentraut [EMAIL PROTECTED] > > > > > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania > 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly