> -----Original Message----- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
