From: Wolfgang.Fuertbauer@ebewe.com
To: pgsql-sql@postgresql.org
Subject: drop constraint problem
Date: Tue, 21 May 2002 09:12:51 +0200
Message-ID: <OFD1BA750D.F628C5CE-ONC1256BC0.00276082@ebewe.co.at> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Wolfgang.Fuertbauer@ebewe.com
Subject: Re: drop constraint problem
In-Reply-To: <OFD1BA750D.F628C5CE-ONC1256BC0.00276082@ebewe.co.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox