Postgres Pro
Downloads
Home   >   mailing lists

Re: information schema/aclexplode doesn't know about default privileges - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: information schema/aclexplode doesn't know about default privileges
Date
Msg-id 9B7F4E16-F517-4086-AA8A-939D9A642E3C@nasby.net
Whole thread Raw
In response to Re: information schema/aclexplode doesn't know about default privileges  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
On Jan 1, 2012, at 10:43 PM, Peter Eisentraut wrote:
> I figured the best and most flexible way to address this is to export
> acldefault() as an SQL function and replace
>
>    aclexplode(proacl)
>
> with
>
>    aclexplode(coalesce(proacl, acldefault('f', proowner)))

It would be nice to provide a convenience function that does the coalesce for you. End users sometimes need this stuff
aswell as info_schema. 
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Should I implement DROP INDEX CONCURRENTLY?
Next
From: Tom Lane
Date:
Subject: Re: Should I implement DROP INDEX CONCURRENTLY?