Re: Fw: Removing foreign key and adding sequence - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Fw: Removing foreign key and adding sequence
Date
Msg-id 1056662840.627.6.camel@billy
Whole thread Raw
In response to Re: Fw: Removing foreign key and adding sequence  ("Chad Thompson" <chad@weblinkservices.com>)
List pgsql-novice
Am Don, 2003-06-26 um 23.19 schrieb Chad Thompson:
> > >  7.32.  Can I just drop the foreign key?  That would be SO much easier
> :-)
> >
> > Since 7.3 it's very easy, but even with 7.2 you could:
> >
> > 7.3:
> > \d table_name
> > if the key is labeled with e.g. $1:
> > ALTER TABLE table_name DROP CONSTRAINT "$1";
> > >
>
> Hrm... What could I be doing wrong?

Your FK are 7.2 style (actually they are < 7.3)
(they are triggers)

> Triggers: RI_ConstraintTrigger_10337839,
>           RI_ConstraintTrigger_10337842,
>           RI_ConstraintTrigger_10337860

Just take the example from 7.2

HTH
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: "Fontenot, Paul"
Date:
Subject: Greater than a value
Next
From: Josh Berkus
Date:
Subject: Re: Greater than a value