Re: Drop foreign keys

Stephan Szabo wrote:

>On Wed, 8 Jan 2003, Andreas Schlegel wrote:
>
>
>>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.
>
That's it! Now all trigger concerning the two tables are removed.

Thanks for help,
Andreas