Re: a bug in pg_dump? - Mailing list pgsql-bugs

From Jaime Casanova
Subject Re: a bug in pg_dump?
Date
Msg-id 20041019204557.91675.qmail@web50005.mail.yahoo.com
Whole thread Raw
In response to Re: a bug in pg_dump?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-bugs
--- Alvaro Herrera <alvherre@dcc.uchile.cl> escribió:

> On Tue, Oct 19, 2004 at 02:25:35PM -0400, Tom Lane
> wrote:
> > Jaime Casanova <systemguards@yahoo.com> writes:
> > > but when i do a: pg_dump -C uescc > uescc.sql
> > > it add the create statement for the database but
> not
> > > add appropiates alter database for the
> parameters i
> > > set search_path in this case.
> >
> > > But, pg_dumpall does.
> >
> > > a bug in pg_dump?
> >
> > No.  That functionality is assigned to pg_dumpall.

Why in pg_dumpall and not in pg_dump -C?


>
> There doesn't seem to be a way of extracting only
> database creation from
> pg_dumpall.  Or the schema of a single database, for
> example.  There
> _is_ a functionality gap here.
>
>
> ISTM pg_dump -C (which dumps CREATE DATABASE) should
> dump ALTER DATABASE
> commands too.

It seems to be the logical behavior, IMHO.

best regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: a bug in pg_dump?
Next
From: Tom Lane
Date:
Subject: Re: BUG #1286: indices not used after a pg_restore