On Tue, Dec 07, 2004 at 11:44:58AM +0800, cheng shan wrote: > 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.
If you want to fire the triggers then delete all records from the table before dropping it. But why are you dropping the table? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match