Dropping Foreign Key without recreating table

From: Egon Reetz <reetz(at)usco(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Dropping Foreign Key without recreating table
Date: 2002-11-24 13:47:50
Message-ID: 3DE0D886.4DE837BB@usco.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I wanted to change a foreign key to be deferrable (db version 7.2.1).
During table creation I didn't specify a constraint name for the foreign
key.
"\d" shows a trigger RI_ConstraintTrigger_17195, however when I'm trying
to "alter table mytable drop constraint RI_ConstraintTrigger_17195
restrict" I'm getting the error "constraint does not exist.
What am I doing wrong here? Or is there another simple solution to
switch foreign keys to be deferrable?

Regards

Egon

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mallah 2002-11-24 14:05:48 Re: Dropping Foreign Key without recreating table
Previous Message Chris Miles 2002-11-24 00:51:30 Re: Cluster Database