Andy Colson <andy@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
