Re: 7.4 - TODO : alter table drop foreign key

On 5 Dec 2002 at 9:02, Stephan Szabo wrote:

> On Thu, 5 Dec 2002, Dan Langille wrote:
> 
> > Found the solution:
> >
> > drop trigger "RI_ConstraintTrigger_4278488" on watch_list_staging;
> 
> Actually there are three triggers for the constraint.  You may have
> dangling triggers on the other table of the constraint.  It's one on the
> table the constraint's defined on and two on the referenced table.
> 
> > Given that the FK in question did not have a name to start with, I
> > concede that it would be difficult to code DROP FOREIGN KEY.
> >
> > What about supporting ALTER TABLE <table> ADD FOREIGN KEY <keyname>
> > ... which at present we don't?  That would then make dropping the FK
> > a simple coding issue?
> 
> ISTM, that's
>  ALTER TABLE <table> ADD CONSTRAINT <name> FOREIGN KEY ...
> which should be there in any 7.x.

Agreed.  But the syntax is different. If we are supporting "ALTER 
TABLE <table> ADD FOREIGN KEY " without a name, why not support it 
with a name?

> And the drop constraint for foreign keys (and the \d display stuff) is new
> in 7.3.

That's going to be much more useful.  I installed 7.3 for testing 
this morning.  Looking at it now, I no longer see a need for a DROP 
FOREIGN KEY. 

Thank you.
-- 
Dan Langille : http://www.langille.org/