Re: RE: finding and removing a constraint...

> The problem is that the syntax
>
> create table SomeTable (
> SomeColumn        int4 references OtherTable ( SomeColumn ),
>  . . .
>
> creates an <unnamed> trigger which you can't drop with drop trigger
> because it doesn't have a name. What you suggest does work for me, i.e.
> deleting from pg_trigger and then adjusting the trigger count in
> pg_class but it is quite cumbersome.

You should be able to, you just have to use the *real* trigger name (first
column in pg_trigger, will look like RI_ConstraintTrigger_<oid> or
something like that) and make sure to "" it because it's a quoted mixed
case name.