pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddrop constraint problem
3+ messages / 3 participants
[nested] [flat]
* drop constraint problem
@ 2002-05-21 07:12 Wolfgang.Fuertbauer@ebewe.com
0 siblings, 2 replies; 3+ messages in thread
From: Wolfgang.Fuertbauer@ebewe.com @ 2002-05-21 07:12 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: drop constraint problem
@ 2002-05-21 13:10 Joel Burton <joel@joelburton.com>
parent: Wolfgang.Fuertbauer@ebewe.com
1 sibling, 0 replies; 3+ messages in thread
From: Joel Burton @ 2002-05-21 13:10 UTC (permalink / raw)
To: Wolfgang.Fuertbauer@ebewe.com; pgsql-sql
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: drop constraint problem
@ 2002-05-22 02:59 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Wolfgang.Fuertbauer@ebewe.com
1 sibling, 0 replies; 3+ messages in thread
From: Christopher Kings-Lynne @ 2002-05-22 02:59 UTC (permalink / raw)
To: Wolfgang.Fuertbauer@ebewe.com; +Cc: pgsql-sql
If y;ou check the manual, you'll notice that Postgres doesn't support
dropping foreign key constraints just yet...
You'll need to delete the three constraints manually from pg_trigger.
This is tricky, but you can dlete them by their name and the oid of the
table that they're on...
Chris
On Tue, 21 May 2002 Wolfgang.Fuertbauer@ebewe.com wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-05-22 02:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-05-21 07:12 drop constraint problem Wolfgang.Fuertbauer@ebewe.com
2002-05-21 13:10 ` Joel Burton <joel@joelburton.com>
2002-05-22 02:59 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
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