Re: Re: CAST doesn't work

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