Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Fuhr
Subject Re: Triggers don't activate when dropping table
Date
Msg-id 20041207092849.GA53771@winnie.fuhr.org
Whole thread Raw
In response to Re: Triggers don't activate when dropping table  (cheng shan <postgresql_general@yahoo.com.cn>)
List pgsql-general
Tree view 
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.ERROR:  could not open relation
> with OID 1390714.

What's happening when you get this error?  If you've been dropping
tables then you might have a problem with cached plans.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Postgres Learner
Date:
Subject: Fwd: 8.0 vs. 7.4 benchmarks
Next
From: "Premsun Choltanwanich"
Date:
Subject: How can I recovery old Data from files and folders on windows?