Re: Trigger isn't fired

From: Harald Fuchs <hf517(at)protecting(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger isn't fired
Date: 2004-06-27 10:12:12
Message-ID: pueko1l37n.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <016601c45c14$136a9570$230a0a0a(at)compaq>,
Együd Csaba <csegyud(at)vnet(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba 2004-06-27 12:12:34 Re: Trigger isn't fired
Previous Message Ilia Kantor 2004-06-27 09:31:43 inner data format