Actually, i'm not sure that making it respect -S is the right way to go. What we really need is an option that specifies the cluster owner on the new installation.

I will revert that part of this patch and resubmit shortly...


Christopher Kings-Lynne wrote:

This patch fixes the following bugs:

* pg_dump --clean against a pre-7.3 server output drop commands in the form: DROP "".foo; . These will now all be output as: DROP;

* If you use ALTER USER to set user params on the cluster owner user, these would not be dumped. This patch will now dump ALTER USER commands for the cluster owner. If the -S command line switch is used to specify a superuser, then the cluster owner ALTER USER commands will be dumped for that user instead.

* The DateStyle and search_path GUC variables must not be quoted when dumped.



---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Reply via email to