Re: Fixes for 3 bugs in pg_dump

#1

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...

Chris

Christopher Kings-Lynne wrote:

Quote:

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 public.foo;

* 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.

Chris

------------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Fixes for 3 bugs in pg_dump

comp.databases.postgresql.patches comp.databases.postgresql.patches

Re: Fixes for 3 bugs in pg_dump - 07-14-2004 , 02:08 AM