| From: | Andrew - Supernews <andrew+nonews(at)supernews(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Views, views, views! (long) |
| Date: | 2005-05-10 18:00:36 |
| Message-ID: | slrnd81tm3.2kch.andrew+nonews@trinity.supernews.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2005-05-10, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> Am Freitag, 6. Mai 2005 12:20 schrieb Andreas Pflug:
>> > and the information_schema is next to useless for these things since
>> > it doesn't have PostgreSQL specific things in it.
>>
>> And the restriction to current user owned objects reduces usability to
>> zero.
>
> The information schema restricts the views to the objects to which you have
> some access right, which doesn't seem all that useless.
Actually that varies according to the individual view. Some restrict to
objects to which you have access, others restrict to objects that you own.
Furthermore, in the latter case there is no exception for superusers.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-05-10 18:07:01 | Re: Oracle Style packages on postgres |
| Previous Message | Jim C. Nasby | 2005-05-10 17:55:00 | Re: Oracle Style packages on postgres |