Josh Berkus <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
