drop constraint problem - Mailing list pgsql-sql

From Wolfgang.Fuertbauer@ebewe.com
Subject drop constraint problem
Date
Msg-id OFD1BA750D.F628C5CE-ONC1256BC0.00276082@ebewe.co.at
Whole thread Raw
Responses Re: drop constraint problem  ("Joel Burton" <joel@joelburton.com>)
Re: drop constraint problem  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Bug with Daylight Savings Time & Interval
Next
From: Markus Wagner
Date:
Subject: constraints for ensuring relationships