| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: information_schema 7.4 |
| Date: | 2003-04-07 17:03:15 |
| Message-ID: | 1049734995.40144.25.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 2003-04-07 at 07:45, Andreas Pflug wrote:
> I like the information_schema namespace included in 7.4, but it at the
> moment it's rather unusable to me because most views are restricted to
> showing only objects owned by the current_user. I regularly need ALL
> objects visible, as long as the user has rights on it.
You're welcome to read up on the SQL spec for Information_schema, but
the spec (to me) declares that the current_user must own or be able to
modify the object to see it.
I'll agree it makes the information_schema somewhat less useful.
--
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-04-07 17:06:07 | Re: more contrib: log rotator |
| Previous Message | Andreas Pflug | 2003-04-07 16:48:55 | pg_get_viewdef 7.4 parentheses |