Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 7CC30475CAA for ; Tue, 21 May 2002 03:12:48 -0400 (EDT) Received: from ebewe.com (unknown [80.120.1.196]) by postgresql.org (Postfix) with ESMTP id 09BB1475BC3 for ; Tue, 21 May 2002 03:11:47 -0400 (EDT) Received: from exim by ebewe.com with spam-scanned (Exim 4.02) id 17A2sC-0006ri-00 for pgsql-sql@postgresql.org; Tue, 21 May 2002 08:11:53 +0200 Received: from horn.intern.ebewe.at ([172.16.5.1] helo=mail.ebewe.co.at) by ebewe.com with esmtp (Exim 4.02) id 17A2sB-0006rd-00 for pgsql-sql@postgresql.org; Tue, 21 May 2002 08:11:52 +0200 Subject: drop constraint problem To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0.9 November 16, 2001 Message-ID: From: Wolfgang.Fuertbauer@ebewe.com Date: Tue, 21 May 2002 09:12:51 +0200 X-MIMETrack: Serialize by Router on Unta_Notes_Srv01/EBEWE/AT(Release 5.0.9a |January 7, 2002) at 21.05.2002 09:12:52 MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) *17A2sB-0006rd-00*84DgShqASq6* X-Spam-Status: No, hits=0.8 required=5.0 tests=NO_REAL_NAME,AWL version=2.20 X-Spam-Level: X-Archive-Number: 200205/215 X-Sequence-Number: 7850 Hi all, i'm running 7.2.1 and have problems with dropping constraints: fakt32=# alter table wkfaktzeilen add constraint printjobfk foreign key (printjob) references wkfaktdruck(printjob) match full on delete cascade on update cascade; >ALTER fakt32=# alter table wkfaktzeilen drop constraint printjobfk restrict; >ERROR: ALTER TABLE / DROP CONSTRAINT: printjobfk does not exist fakt32=# alter table wkfaktdruck drop constraint printjobfk restrict; >ERROR: ALTER TABLE / DROP CONSTRAINT: printjobfk does not exist but when dropping the table, the triggers are deleted and i can see the entries in pg_triggers?? please help Wolfgang