On Mon, Dec 15, 2008 at 11:38 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> I wrote:
>> ... But this type of problem has come
>> up before.  I wonder if we shouldn't do what was previously discussed:
>> make has_table_privilege and related functions silently return FALSE,
>> instead of throwing error, when given a "nonexistent" OID.
>
> On checking the archives, it seems most of the previous complaints have
> been about "cache lookup failed" errors arising from pg_table_is_visible
> and its ilk; those are used in the queries generated by psql's \d
> commands.
>
> So my proposal is to change the OID-accepting variants of
> has_table_privilege and friends, as well as pg_table_is_visible and
> friends, to silently return FALSE instead of failing when given a
> bad OID.  I had originally thought we might change the underlying

Or maybe NULL?

...Robert

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to