Re: Fw: Removing foreign key and adding sequence

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Chad Thompson <chad(at)weblinkservices(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Fw: Removing foreign key and adding sequence
Date: 2003-06-27 16:47:29
Message-ID: 1056732448.583.2.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-06-27 19:35:14 ERROR: tuplestore_gettuple: invalid state
Previous Message Tom Lane 2003-06-27 15:39:59 Re: Which GRANTS are needed on a Sequnce?