Re: Old/New - Mailing list pgsql-general

From Bob Pawley
Subject Re: Old/New
Date
Msg-id 6778716F973443228EC7F59E628B0B60@desktop
Whole thread Raw
In response to Old/New  ("Bob Pawley" <rjpawley@shaw.ca>)
Responses Re: Old/New
List pgsql-general
No

The table p_id.processes is the start of the fluid_id ident and that column
is serial.

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 3:19 PM
Subject: Re: [GENERAL] Old/New


On Friday 22 January 2010 3:05:54 pm Bob Pawley wrote:
> This is the whole trigger
>
>
>
>  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

The update statement -
update p_id.processes
set pump1 = 'True'
where p_id.processes.fluid_id = '3501' ;
updates the field pump1 to 'True'.

Is there more than one row in p_id.processes with p_id.processes.fluid_id
= '3501' ?



--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Old/New
Next
From: PG User 2010
Date:
Subject: VACUUM FULL performance issues with pg_largeobject table