Re: Large Object permissions lost in transfer

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