Re: [GENERAL] Triggers don't activate when dropping table

2004-12-07 Thread Stephan Szabo
On Tue, 7 Dec 2004, cheng shan wrote: >In the first version, the function destroy_object_type( ) just drop the >table only. But when I find the triggers havn't >been actived yet, I add the delete setense. This time it becomes even >worse, the system throws error message.ERROR: could >not open r

Re: [GENERAL] Triggers don't activate when dropping table

2004-12-07 Thread Michael Fuhr
On Tue, Dec 07, 2004 at 02:41:37PM +0800, cheng shan wrote: > In the first version, the function destroy_object_type( ) just drop > the table only. But when I find the triggers havn't been actived > yet, I add the delete setense. This time it becomes even worse, > the system throws error message.

Re: [GENERAL] Triggers don't activate when dropping table

2004-12-06 Thread cheng shan
Note: forwarded message attached. Do You Yahoo!? 注册世界一流品质的雅虎免费电邮--- Begin Message --- The reason I drop the table directly is that:   I am developing a graphical information system. There are many tables inherit from object in the system, such as "map", "line", "rect", "circle", etc. In most tim

Re: [GENERAL] Triggers don't activate when dropping table

2004-12-06 Thread Michael Fuhr
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 ma

[GENERAL] Triggers don't activate when dropping table

2004-12-06 Thread cheng shan
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