From: | Howard Cole <howardnews(at)selestial(dot)com> |
---|---|
To: | Andy Colson <andy(at)squeakycode(dot)net> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Large Object permissions lost in transfer |
Date: | 2011-04-05 00:03:29 |
Message-ID: | 4D9A5C51.4080704@selestial.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> 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$$;
>
>
> I wanted to change the owner.. where-as you want grant... but it
> should get you the idea.
>
> -Andy
>
Thanks All, Especially Andy. I shall not bother thanking Tom because in
his omnipient state - He knows! ;)
Assistance on this forum is soooo good. It puts most of the support I
pay for to shame. (for non postgres stuff)
Howard.
From | Date | Subject | |
---|---|---|---|
Next Message | C. Bensend | 2011-04-05 00:12:04 | Plpgsql function to compute "every other Friday" |
Previous Message | Craig Ringer | 2011-04-04 23:59:41 | Re: Foreign key and locking problem |