Jason Davis <jdavis@tassie.net.au> writes:
> Is it possible to remove a referential integrity trigger without dropping
> tables? I tried to DROP TRIGGER using the name of the trigger created from
> the foreign key clause when the table was created, without success (no such
> trigger name).
Were you careful about case sensitivity? The RI trigger names are
deliberately made mixed-case to reduce the odds of collision with user
trigger names... but AFAIK you should be able to drop 'em if you quote
'em correctly.
regards, tom lane