| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "Tony Marston" <tony(at)marston-home(dot)demon(dot)co(dot)uk> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, "'Stephan Szabo'" <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Subject: | Re: BUG #1937: Parts of information_schema only accessible to owner |
| Date: | 2005-10-09 16:42:01 |
| Message-ID: | 200510091842.02518.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2005-10-09 17:19:46 | Re: BUG #1947: Enhancement Request - CONCAT() function |
| Previous Message | Peter Eisentraut | 2005-10-09 16:37:17 | Re: BUG #1937: Parts of information_schema only accessible to owner |