Triggers don't activate when dropping table

Поиск
Список
Период
Сортировка
От cheng shan
Тема Triggers don't activate when dropping table
Дата
Msg-id 20041207034458.32216.qmail@web15505.mail.cnb.yahoo.com
обсуждение исходный текст
Ответы Re: Triggers don't activate when dropping table
Список 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 по дате отправления:

Предыдущее
От: Andrew - Supernews
Дата:
Сообщение: Re: Index scan vs. Seq scan on timestamps
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Detecting Temporary Tables