Re: [BUGS] pg_dumpall (7.3) two search_path schema bugs

2004-11-16 Thread Tom Lane
"Karl O. Pinc" <[EMAIL PROTECTED]> writes: > It appears as though pg_dumpall is setting the search_path > runtime variable in the databases before it creates the > schemas. Further, it appears as though the ALTER > DATABASE command used to set the search path does > not have the quotes correct. T

[BUGS] pg_dumpall (7.3) two search_path schema bugs

2004-11-16 Thread Karl O. Pinc
Hi, Went to upgrade from postgresql (RedHat's postgresql rh-postgresql-7.3.6-7) to Fedora core 3 postgresql 7.4.6-1 and encountered a problem. If nothing else this is worth a note on the 7.4 upgrade doc page. It appears as though pg_dumpall is setting the search_path runtime variable in the databa