Hi All
I have three tables
Create Table Pipe
( pipe_id serial ,
fluid_id int4
) ;
Create Table Equipment
(Equipment_id serial,
fluid_id int4
) ;
Create Table Processes
( Fluid_id serial
fluid varchar (15),
ip_op_equipment varchar (5)
) ;
The interface inserts the name
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
that you referred to?
Bob
- Original Message -
From: Tomas Vondra [EMAIL PROTECTED]
To: pgsql-general@postgresql.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
PROTECTED]
To: pgsql-general@postgresql.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
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.
OK, now I understand.
I didn't include the after insert trigger as there can't be a trigger
until the ip_op_equipment is updated.