Dropping Foreign Key without recreating table - Mailing list pgsql-admin

From Egon Reetz
Subject Dropping Foreign Key without recreating table
Date
Msg-id 3DE0D886.4DE837BB@usco.de
Whole thread Raw
Responses Re: Dropping Foreign Key without recreating table
Re: Dropping Foreign Key without recreating table
List 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



pgsql-admin by date:

Previous
From: Chris Miles
Date:
Subject: Re: Cluster Database
Next
From:
Date:
Subject: Re: Dropping Foreign Key without recreating table