Re: Proposed TODO: CREATE .... WITH OWNER;

Josh Berkus <josh@agliodbs.com> writes:
> Instead, we should have a "CREATE .... WITH OWNER username" extension to all 
> of our CREATE <object> statements.

The main objection to this is that it makes the dump completely
unportable.

> CREATE followed by ALTER ... CHANGE OWNER would not be an adequate substitute.  
> The orginal owner of the object (in the case of a restore, the superuser) 
> retains all of their permissions on the object, which causes a lot of messy 
> GRANT statements.

Not in 8.0.
        regards, tom lane