a bug in pg_dump?

From: Jaime Casanova <systemguards(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: a bug in pg_dump?
Date: 2004-10-19 17:38:10
Message-ID: 20041019173810.57783.qmail@web50010.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi all,

I have database with 6 schemas, i did an:
alter database set search_path to 'public',
'pg_catalog', 'academico', 'dobe', 'recaudaciones',
'becas', 'roles', 'seguridad'

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?

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-10-19 18:25:35 Re: a bug in pg_dump?
Previous Message Tom Lane 2004-10-19 13:56:08 Re: Time intervals in select statement