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@xxxxxxxx>
To: <pgsql-general@xxxxxxxxxxxxxx>
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
