Re: Old/New

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@gmail.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>; "Postgresql"
<pgsql-general@postgresql.org>
Sent: Friday, January 22, 2010 1:11 PM
Subject: Re: [GENERAL] 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@gmail.com
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general