Re: Re: Problem with disabling triggers in pg_dump

Tom Lane writes:

> We have talked about ways to solve the real problem. One way is to
> run the entire restore script as superuser, doing something other than
> \connect to set ownership of created objects. You could do that now
> with something like
> create table newtable ...
> update pg_class set relowner = xxx where relname = 'newtable';
> although it'd be nicer to invent ALTER commands to handle this.

And this is what good ol' SQL has in store for us:

CREATE SCHEMA AUTHORIZATION "username"
CREATE TABLE t1 (...)
CREATE TABLE t2 (...)
;

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden