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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
