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