| 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: | Whole Thread | Raw Message | 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
| 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%'; |