Re: Fixes for 3 bugs in pg_dump - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: Fixes for 3 bugs in pg_dump
Date
Msg-id 40F4DBE2.6080006@familyhealth.com.au
Whole thread Raw
In response to Fixes for 3 bugs in pg_dump  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-patches
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:

> 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@postgresql.org)

pgsql-patches by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Fixes for 3 bugs in pg_dump
Next
From: Simon Riggs
Date:
Subject: Re: PITR Archive Recovery plus WIP PITR