I have a single row that is being duplicated on insert.
Update statement -
update p_id.processes
set pump1 = 'True'
where p_id.processes.fluid_id = '3501' ;
The proper field is updated.
Bob
----- Original Message -----
From: "Adrian Klaver" <adrian.klaver@xxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Tom Lane" <tgl@xxxxxxxxxxxxx>; "Postgresql"
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Friday, January 22, 2010 1:11 PM
Subject: Re: Old/New
On 01/22/2010 01:05 PM, Bob Pawley wrote:
Begin
If new.pump1 = 'True'
then
Insert into p_id.devices (p_id_id, process_id, fluid_id, status,
process_graphics_id, device_description)
values (new.p_id_id, new.process_id, new.fluid_id, 'Pump #1', '11',
'Pump');
End if;
If new.pump2 = 'True'
then
Insert into p_id.devices (p_id_id, process_id, fluid_id, status,
process_graphics_id, device_description)
values (new.p_id_id, new.process_id, new.fluid_id, 'Pump #2', '11',
'Pump');
End if ;
RETURN NULL;
END;
Bob
This is different from what you originally posted. Is the above still
causing problems?
Yes. The above inserts two versions of the same row.
Some detail is in order. Two versions of what row? Also what is your
update statement?
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
