acl_admin by Afilias CA (bug/feature report)

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: acl_admin by Afilias CA (bug/feature report)
Date: 2009-08-06 09:19:15
Message-ID: 20090806111915.38b069e0@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I can't find any more the place from where I downloaded acl_admin.
There is a very small problem with chown_all

Since a sequence may be owned by a table... and the function may try
to change the ownership of the seq first the function may abort
earlier.

A quick hack that may works in most situations would be to order the
select looping through relations since generally sequences have
"longer" names than related tables.

I haven't seen any change in that tool and it seems it dates back to
2004. Are there any more modern/complete tools for mass change of
ownership/grant around?

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2009-08-06 10:00:42 PG fails on Windows Server 2008: could not reattach to shared memory ... : 487
Previous Message Richard Huxton 2009-08-06 08:18:07 Re: LISTEN ON table WHERE attr1 LIKE '%abc%';