From: | "Reggie Burnett" <rykr(at)bellsouth(dot)net> |
---|---|
To: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'Peter Eisentraut'" <peter_e(at)gmx(dot)net> |
Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Dave Cramer'" <dave(at)fastcrypt(dot)com>, "'PostgreSQL Hackers Mailing List'" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Request for qualified column names |
Date: | 2003-01-28 22:23:23 |
Message-ID: | 005b01c2c71b$e26e5080$c600a8c0@endeavor |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)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(at)gmx(dot)net
> >
> >
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania
> 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Reggie Burnett | 2003-01-28 22:24:57 | Re: Request for qualified column names |
Previous Message | Tom Lane | 2003-01-28 22:21:55 | Re: Request for qualified column names |