Skip site navigation (1) Skip section navigation (2)

Re: Trigger isn't fired

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: hf517(at)protecting(dot)net, pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger isn't fired
Date: 2004-06-27 12:12:34
Message-ID: 000001c45c40$07def0d0$230a0a0a@compaq (view raw or flat)
Thread:
Lists: pgsql-general
Yes, yes you are right. :)
I had already modified that (using TG_OP variable) before I posted the
letter just didn't mentioned.
By the way the trigger does its task. Rally. :)

Thanks,
  -- Csaba

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Harald Fuchs
> Sent: 2004. június 27. 12:12
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Trigger isn't fired
>
>
> 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.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.712 / Virus Database: 468 - Release Date: 2004. 06. 27.
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 2004. 06. 27.



In response to

pgsql-general by date

Next:From: eetemadiDate: 2004-06-27 14:13:43
Subject: Date localization
Previous:From: Harald FuchsDate: 2004-06-27 10:12:12
Subject: Re: Trigger isn't fired

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group