On Mon, Oct 5, 2009 at 12:48 PM, Dmitry Samokhin <sdld(at)mail(dot)ru> wrote:
> To implement this in case of empty, but not null, ACL of functions (and
> other database objects granting default access to PUBLIC), the
> reverse-engineering procedure of pgAdmin might be modified for the script to
> look like:
>
> CREATE OR REPLACE FUNCTION ... ;
> ALTER FUNCTION ... OWNER TO <owner>;
> REVOKE ALL ON FUNCTION ... FROM public;
> REVOKE ALL ON FUNCTION ... FROM <owner>;
Thanks, fixed in SVN for 1.10.1.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com