Re: [BUGS] pg_dump problem

2000-08-04 Thread Philip Warner
At 22:05 3/08/00 -0300, Paulo Roberto Siqueira wrote: > >Why doesn't pg_dump give me foreign keys constraints? It happens to all the >tables with foreign keys. pg_dump does not restore the database by executing the same set of commands as you used to create the database. Foreign key constraints a

[BUGS] pg_dump problem

2000-08-04 Thread Paulo Roberto Siqueira
PgSQL 7.0.2 I used pg_dump to dump the schema of a db. I created table part_presencial with this command create table part_presencial( login char(15) not null, id_curso_polo int4 not null, data_encontro date not null, nota numeric(2,2) null, foreign key(login,id_curso_polo) refer