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@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden