Re: [GENERAL] pg_dump/pg_dumpall do not correctly dump search_path

2004-09-10 Thread Bruce Momjian
Would someone answer this report?. Looks strange to me. --- Ben Trewern wrote: > All, > > There seems to be a bug in pg_dumpall: > > For one of my dbs I've done: > > ALTER DATABASE dbname SET search_path = mw, public; >

[GENERAL] pg_dump/pg_dumpall do not correctly dump search_path

2004-09-09 Thread Ben Trewern
All, There seems to be a bug in pg_dumpall: For one of my dbs I've done: ALTER DATABASE dbname SET search_path = mw, public; If I do a pg_dumpall I get a line like: ALTER DATABASE dbname SET search_path TO 'mw, public'; note the 's. It's also in a place in the dump before the mw schema is created