Re: [ADMIN] pg_dump trouble

2004-09-26 Thread Michael Fuhr
On Fri, Sep 24, 2004 at 02:33:59PM +0200, gauthier lawny wrote: > > I got 2 tables like > create table mytable(idnop serial, other varchar, > primary key (idnop)); > create table reftable(idnop integer references > mytable, primary key (idnop)); > > pgsql create implicitly a sequence to handle the

[ADMIN] pg_dump trouble

2004-09-24 Thread gauthier lawny
Here is the trouble I encountered. I got 2 tables like create table mytable(idnop serial, other varchar, primary key (idnop)); create table reftable(idnop integer references mytable, primary key (idnop)); pgsql create implicitly a sequence to handle the idnop serial. I perfomed some insertions in