Re: Large Object permissions lost in transfer

Andy Colson <andy@squeakycode.net> writes:
> On 4/4/2011 9:19 AM, Howard Cole wrote:
>> Thanks Andy. As a temporary measure I am going to use the server
>> configuration variable lo_compat_privileges when I work out how to use
>> it. For the longer term, could I borrow your script for the DO :)

> I dont seem to have it anymore... but here is a re-created, untested
> version.

> do $$
> delcare r record;
> begin
> for r in select loid from pg_catalog.pg_largeobject loop
>    execute 'ALTER LARGE OBJECT ' || r.loid || ' OWNER TO andy';
> end loop;
> end$$;

Suggest "select distinct loid" to avoid a lot of duplicated work,
otherwise this should be fine.

            regards, tom lane