information schema/aclexplode doesn't know about default privileges

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: information schema/aclexplode doesn't know about default privileges
Date: 2011-11-27 18:47:21
Message-ID: 1322419641.29401.5.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Try this:

create function foo(int) returns int as $$ select $1 $$ language sql;

select * from information_schema.routine_privileges;

This ought to show EXECUTE privilege on the new function, but it
doesn't, because proacl is null, and nothing in the information schema
handles that specially.

I've pondered some ways to fix that. One would be to add a variant of
aclexplode() that takes a parameter telling which catalog the acl datum
came from, and aclexplode() could then substitute the data received
acldefault() for null values. The other way would be to handle this
entirely in the information schema SQL (either using some coalesce calls
or perhaps a UNION). But that would mean duplicating the knowledge of
acldefault() in a second remote place. So I'm thinking that handling it
in aclexplode() would be better.

Comments?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2011-11-27 19:11:28 Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)
Previous Message Tom Lane 2011-11-27 18:43:37 Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)