Received: from rimbaud.uol.com.br ([200.231.206.24]) by hub.org (8.10.1/8.10.1) with ESMTP id e721LbB84192 for ; Tue, 1 Aug 2000 21:21:37 -0400 (EDT) Received: from maximus (200-191-90-191-as.acessonet.com.br [200.191.90.191]) by rimbaud.uol.com.br (8.9.1/8.9.1) with SMTP id WAA02398 for ; Tue, 1 Aug 2000 22:20:21 -0300 (BRT) From: "Paulo Roberto Siqueira" To: "PGSQL Admin" Subject: pg_dump problem Date: Tue, 1 Aug 2000 22:20:40 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Importance: Normal X-Archive-Number: 200008/1 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) references matricula, foreign key(id_curso_polo,data_encontro) references presencial, primary key(login,id_curso_polo,data_encontro)); But pg_dump gives me this: CREATE TABLE "part_presencial" ( "login" char(15) NOT NULL, "id_curso_polo" int4 NOT NULL, "data_encontro" date NOT NULL, "nota" numeric(2,2), PRIMARY KEY ("login", "id_curso_polo", "data_encontro") ); Why doesn't pg_dump give me foreign keys constraints? It happens to all the tables with foreign keys. ----- Paulo Roberto Siqueira paulo.siqueira@usa.net Database Administrator Goiania - GO - Brazil