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

2004-12-06 Thread cheng shan
ows error message.ERROR:  could not open relation with OID 1390714.   To avoid the fatal error, I have no choice but to rollback the function to the original version.   I have written a simplified test cast to verify the system, but it performs as I expected and it's wrong.   Could you help

[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

[GENERAL] Errors when deleting cords and droping table at the same time

2004-11-26 Thread Cheng Shan
Hello!    Every one.    I met some difficult questions when I was developing an application.    We have an old table object whose definition is:   CREATE TABLE object ( name name, -- object’s name pid oid,    -- parent’s object ID