On 4/4/2011 6:12 AM, Howard Cole wrote:
I have recently transferred data from 8.4 to 9.0 and now only my
superuser has read access to the large objects.
(The transfer was done using pg_dump version 9.0).
The large objects have all transferred, the problem is just the
permissions, - but how do I set up the permissions for the large objects?
Thanks,
Howard Cole
www.selestial.com
I had the same problem. and there is no grant all... there is the new
DO though. That's what I used, a simple DO expression to iterate and
update the permissions.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
