Triggers don't activate when dropping table

From: cheng shan <postgresql_general(at)yahoo(dot)com(dot)cn>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Triggers don't activate when dropping table
Date: 2004-12-07 03:44:58
Message-ID: 20041207034458.32216.qmail@web15505.mail.cnb.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!?
注册世界一流品质的雅虎免费电邮

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2004-12-07 03:45:08 Re: When to encrypt
Previous Message Andrew - Supernews 2004-12-07 03:13:04 Re: Index scan vs. Seq scan on timestamps