Triggers don't activate when dropping table - Mailing list pgsql-general

From cheng shan
Subject Triggers don't activate when dropping table
Date
Msg-id 20041207034458.32216.qmail@web15505.mail.cnb.yahoo.com
Whole thread Raw
Responses Re: Triggers don't activate when dropping table  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
I have one table named "object" and i many tables that are related to the table "object". When a record in "object" is deleted, the relative records in other tables should also be erased.  To implement the above goal,  i define many triggers on table "object" to make operations automatically.
 
But i find that the triggers don't activate when i dropping the table "object". So there is many garbage information left in the system which makes the system unstable.
 
Could anyone help?
Thank you!
                                                                     simon



Do You Yahoo!?
注册世界一流品质的雅虎免费电邮

pgsql-general by date:

Previous
From: Andrew - Supernews
Date:
Subject: Re: Index scan vs. Seq scan on timestamps
Next
From: Michael Fuhr
Date:
Subject: Re: Detecting Temporary Tables