From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andy Colson <andy(at)squeakycode(dot)net> |
Cc: | Howard Cole <howardnews(at)selestial(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Large Object permissions lost in transfer |
Date: | 2011-04-04 17:45:11 |
Message-ID: | 2447.1301939111@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andy Colson <andy(at)squeakycode(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Gainty | 2011-04-04 19:07:38 | ..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language.. |
Previous Message | Andy Colson | 2011-04-04 17:42:40 | Re: Large Object permissions lost in transfer |