Re: Triggers don't activate when dropping table - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Triggers don't activate when dropping table
Date
Msg-id 20041207041425.R82778@megazone.bigpanda.com
Whole thread Raw
In response to Re: Triggers don't activate when dropping table  (cheng shan <postgresql_general@yahoo.com.cn>)
List pgsql-general
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 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.

Once I remove the bare text from the test case, my 8.0b3 system seems to
run the whole thing pasted in with no errors. What version are you trying
it against?

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Index on geometry and timestamp
Next
From: Stephan Szabo
Date:
Subject: Re: Index scan vs. Seq scan on timestamps