Re: Triggers don't activate when dropping table

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: cheng shan <postgresql_general(at)yahoo(dot)com(dot)cn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers don't activate when dropping table
Date: 2004-12-07 09:28:49
Message-ID: 20041207092849.GA53771@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Premsun Choltanwanich 2004-12-07 09:48:43 How can I recovery old Data from files and folders on windows?
Previous Message Postgres Learner 2004-12-07 09:17:58 Fwd: 8.0 vs. 7.4 benchmarks