Postgres Pro
Downloads
Home   >   mailing lists

Re: Proposed TODO: CREATE .... WITH OWNER; - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposed TODO: CREATE .... WITH OWNER;
Date
Msg-id 29281.1098576352@sss.pgh.pa.us
Whole thread Raw
In response to Proposed TODO: CREATE .... WITH OWNER;  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Proposed TODO: CREATE .... WITH OWNER;
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Proposed TODO: CREATE .... WITH OWNER;
Next
From: Josh Berkus
Date:
Subject: Re: Proposed TODO: CREATE .... WITH OWNER;