Re: Request for qualified column names - Mailing list pgsql-hackers

From Reggie Burnett
Subject Re: Request for qualified column names
Date
Msg-id 005b01c2c71b$e26e5080$c600a8c0@endeavor
Whole thread Raw
In response to Re: Request for qualified column names  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: "Reggie Burnett"
Date:
Subject: Re: Request for qualified column names
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] Cannot connect to the database (PG 7.3)