Re: BUG #1937: Parts of information_schema only accessible to owner
От | Tony Marston |
---|---|
Тема | Re: BUG #1937: Parts of information_schema only accessible to owner |
Дата | |
Msg-id | 000101c5cd05$5bdcba50$c800a8c0@ajmnotebook обсуждение исходный текст |
Ответ на | Re: BUG #1937: Parts of information_schema only accessible to owner (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-bugs |
> -----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
В списке pgsql-bugs по дате отправления: