Re: Trigger isn't fired - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Trigger isn't fired
Date
Msg-id pueko1l37n.fsf@srv.protecting.net
Whole thread Raw
In response to Re: Trigger isn't fired  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: Trigger isn't fired  (Együd Csaba <csegyud@vnet.hu>)
List pgsql-general
In article <016601c45c14$136a9570$230a0a0a@compaq>,
Együd Csaba <csegyud@vnet.hu> writes:

> Hi Stephan,
> it was the problem, but not realy understand the reason. The documentetion
> sais that perform doesn't porvide the return value and I thought I do not
> need that. But I read absently, and didn't realized that the query to
> perform must be a SELECT.

> Thank you for opening my eyes. :) Now the trigger does its task.

Does it really?  You're using NEW.productid, which should be undefined
for a DELETE trigger.

pgsql-general by date:

Previous
From: Együd Csaba
Date:
Subject: Re: Trigger isn't fired
Next
From: Együd Csaba
Date:
Subject: Re: Trigger isn't fired