Re: After Update Triggers

From: Bob Pawley <rjpawley(at)shaw(dot)ca>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>, pgsql-general(at)postgresql(dot)org
Subject: Re: After Update Triggers
Date: 2006-11-17 23:49:09
Message-ID: 007101c70aa2$fa0ffd00$8e904618@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am attempting to distribute the fluid from the process table to its own
table (pipe or equipment) depending on whether the fluid is classified as
op, ip or eq.

I didn't include the after insert trigger as there can't be a trigger until
the ip_op_equipment is updated.

BTW what is TG_OP that you referred to?

Bob

----- Original Message -----
From: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, November 17, 2006 3:34 PM
Subject: Re: [GENERAL] After Update Triggers

>> When I trigger 'after insert' the function doesn't work because the
>> ip_op_equipment condition is an update. When I manually enter directley
>> into the table this trigger works fine when both the fluid and
>> ip_op_equipment are entered as one entry.
>>
>> When I trigger 'after update' every row in the Processes table is
>> inserted into the other tables depending on the conditionals. I end up
>> with multiple inserts of the same information.
>>
>> Is it possible to create a trigger that inserts only one row for each
>> entry?
>
> Hello,
>
> I've read the whole message several times and I have to admit I still
> don't understand what are you trying to do or what is going wrong.
>
> I'm not sure what do you mean by 'when I trigger after insert' - the
> trigger is defined as AFTER UPDATE so naturally it does not fire in case
> of an INSERT.
>
> Anyway the point is you can define the trigger as AFTER INSERT OR UPDATE
> and use TG_OP variable, or maybe define several triggers - one for the
> UPDATE, one for the INSERT.
>
> Tomas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2006-11-17 23:55:08 Re: Allowing SYSDATE to Work
Previous Message Reece Hart 2006-11-17 23:44:49 Re: Copy command to load data into a PostgreSQL DB