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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Jaime Casanova <systemguards (AT) yahoo (DOT) com> writes:
No. That functionality is assigned to pg_dumpall.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

On Tue, Oct 19, 2004 at 02:25:35PM -0400, Tom Lane wrote:
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.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
You liked Linux a lot when he was just the gawky kid from down the block
mowing your lawn or shoveling the snow. But now that he wants to date
your daughter, you're not so sure he measures up. (Larry Greenemeier)


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

--- Alvaro Herrera <alvherre (AT) dcc (DOT) uchile.cl> escribió:

Why in pg_dumpall and not in pg_dump -C?


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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html