> 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 upda
t; - Original Message -
> From: "Tomas Vondra" <[EMAIL PROTECTED]>
> To:
> 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
t is TG_OP that you referred to?
Bob
- Original Message -
From: "Tomas Vondra" <[EMAIL PROTECTED]>
To:
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 t
> 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
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
