drop constraint problem

From: Wolfgang(dot)Fuertbauer(at)ebewe(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: drop constraint problem
Date: 2002-05-21 07:12:51
Message-ID: OFD1BA750D.F628C5CE-ONC1256BC0.00276082@ebewe.co.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Wagner 2002-05-21 10:08:08 constraints for ensuring relationships
Previous Message Josh Berkus 2002-05-21 05:57:46 Re: [SQL] Bug with Daylight Savings Time & Interval