On Mon, 23 Apr 2001, Tom Lane wrote:
> 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.
(possibly, Jason, what you think is the trigger name isnt'.)
When your RI triggers are created by PostgreSQL, it chooses the trigger
name itself (what Tom is referring to, above).
The name *you* provide (via a "constraint xxxx references" clause) becomes
a different column, tgconstrname. Check *there* for your trigger name.
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington