Re: [ADMIN] bug found in the dump/restore process

2000-10-04 Thread David Huttleston Jr
Hey Cristóvão, I've met this bug also. I wrote a python script (included below) to cleanup the pg_dump files. Please read the 'Usage Notes' below. I dump my schema and data separately, so I run this script against the schema file. It adds any missing double quotes to the CREATE TABLE s

[ADMIN] bug found in the dump/restore process

2000-10-04 Thread Cristóvão Dalla Costa
Here's the story: * I created a table with a SERIAL type * I decided i'd rather insert the ids manually, so I dropped the sequence * when trying to restore from backup, psql fails because there's no sequence, and pg_dump created the table definition as if the sequence was still there * I removed