Re: BUG #1937: Parts of information_schema only accessible to owner

> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e@gmx.net]
> Sent: 09 October 2005 17:42
> To: Tony Marston
> Cc: pgsql-bugs@postgresql.org; 'Stephan Szabo'
> Subject: Re: [BUGS] BUG #1937: Parts of information_schema
> only accessible to owner
>
>
> Tony Marston wrote:
> > I disagree. The function description in the SQL 1999 standard says
> > "Identify the columns of tables defined in this catalog that are
> > accessible to a given user." It is clear that the actual
> code sample
> > given does not conform to this description,
>
> First of all, the current implementation certainly
> "identifies" all the
> desired columns, because you can clearly get the "identity" of all
> columns from that view.
>
> Moreover, the functional description does not say anything about the
> details of the view, leaving that to the formal definition below.  If
> we followed your reading of the standard, the view would simply give
> the names of the columns along with table and schema name and that's
> all.

I'm sure that if you actually implemented that interpretation you would get
more complaits than you could handle.

Tony Marston

http://www.tonymarston.net