Re: Drop foreign keys

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Andreas Schlegel <schlegelaw(at)gmx(dot)de>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Drop foreign keys
Date: 2003-01-08 21:59:07
Message-ID: 20030108135816.D81899-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 8 Jan 2003, Andreas Schlegel wrote:

> Stephan Szabo wrote:
>
> >>I created some references with foreign keys. But now I have to drop
> >>some of the references. What is the way to do this? Is there a command
> >>for this? Or have I drop the table and recreate it?
> >>Postgres gave the references names like "RI_ConstraintTrigger_494516".
> >>If there is a way to drop them one by one how do I get the information
> >>on which foreign key point these Postgres names?
> >>
> >>
> >>
> >What version are you using?
> >
> Sorry, I forgot: 7.2.1
>
> >In previous versions, you'll need to manually drop the
> >three triggers that are created (you can find the correct
> >triggers by looking for tgconstrname='tPerson_FK03') and
> >you'll need to double quote the tgname for DROP TRIGGER
> >commands.
> >
> I found 3 constrains for this reference. I dropped successfully the
> first. But when I tried to drop the second and the third I got the message:
> "ERROR: DropTrigger: there is no trigger RI_ConstraintTrigger_494494 on
> relation tperson. "
>
> I checked the table (\d tperson) and indeed they diappeared. But I in
> the table pg_trigger I still see the the other, which were refused to drop!
>
> Any idea what went wrong?

Two of the triggers actually exist on the table the reference was to (not
the table making the reference). I'd forgotten to mention that in the
above, sorry.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-08 22:14:49 Re: too many Fatal Error 1: shutdown messages
Previous Message Andreas Schlegel 2003-01-08 21:57:45 Re: Drop foreign keys