Re: [GENERAL] pg_dump without oids

2007-01-17 Thread Tom Lane
=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> writes: > pg_dump and pg_dumpall have the -o option that should tell them to > include oids in dump. I didn't chose this option, and the dump doesn't > include "WITH OIDS", but the tables are created with oids when restoring > this dump.

[GENERAL] pg_dump without oids

2007-01-17 Thread Stéphane Schildknecht
Hi all, pg_dump and pg_dumpall have the -o option that should tell them to include oids in dump. I didn't chose this option, and the dump doesn't include "WITH OIDS", but the tables are created with oids when restoring this dump. I'm dumping from 7.4.5 to 8.2.1. I do have #default_with_oids = off