Re: Request for qualified column names
От | Reggie Burnett |
---|---|
Тема | Re: Request for qualified column names |
Дата | |
Msg-id | 005b01c2c71b$e26e5080$c600a8c0@endeavor обсуждение исходный текст |
Ответ на | Re: Request for qualified column names (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-hackers |
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:pgman@candle.pha.pa.us] > 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 peter_e@gmx.net > > > > > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania > 19073
В списке pgsql-hackers по дате отправления: