On Mon, Dec 15, 2008 at 11:38 AM, Tom Lane <tgl@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