On Monday, April 04, 2011 6:47:44 am Andy Colson wrote: > 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? Is to late to redo the dump/restore? If not you may want to take a look at: http://www.postgresql.org/docs/9.0/interactive/runtime-config- compatible.html#GUC-LO-COMPAT-PRIVILEGES > > > > 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 -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
