Re: Orphaned trigger -- bug? - Mailing list pgsql-general

From Tom Lane
Subject Re: Orphaned trigger -- bug?
Date
Msg-id 20567.1081482723@sss.pgh.pa.us
Whole thread Raw
In response to Orphaned trigger -- bug?  (Mark Lubratt <mark.lubratt@indeq.com>)
List pgsql-general
Mark Lubratt <mark.lubratt@indeq.com> writes:
> I just ran across a situation where I dropped a table that had a
> trigger created on it.  The system let me drop the table without
> complaining and then I realized/remembered that the trigger also
> existed.

Not any more --- triggers on a table certainly are dropped when the
table is dropped.  The function called by a trigger wouldn't be
dropped though; is that what you meant?

            regards, tom lane

pgsql-general by date:

Previous
From: "Siew Hui, Wong"
Date:
Subject: Error in function to pg_dump: Standard in must be a tty
Next
From: Tom Lane
Date:
Subject: Re: Error Message from pgsql v7.3.6