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. I tried dropping the trigger, but of course that couldn't be
done because the target relation no longer existed. Of course I
couldn't remake a relation because that would have a different OID.
The only way I found to drop the trigger was to drop the entire
database.

Shouldn't the system complain about triggers being dependent on
relations the same way that dropping a table that is used in a view
isn't allowed?

Thanks!
Mark


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Mark Lubratt <mark.lubratt@indeq.com> writes:[color=blue]
> 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.[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org