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 1056732448.583.2.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 Fre, 2003-06-27 um 17.30 schrieb Chad Thompson:
>  drop trigger "RI_ConstraintTrigger_10337860" on lists;
>
> worked perfectly! Thanks
>
> How come I have to do the 7.2 method when I have 7.3?

Your db has initially been created with < 7.3 and was migrated to 7.3.
Because it't not a trivial task to automatically convert the triggers to
'real' foreign keys, you still have them as triggers.

bye
--
 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: Tom Lane
Date:
Subject: Re: Which GRANTS are needed on a Sequnce?
Next
From: Heiko.Kehlenbrink@vermes.fh-oldenburg.de
Date:
Subject: plpgsql rowtype