Re: Old/New
От | Bob Pawley |
---|---|
Тема | Re: Old/New |
Дата | |
Msg-id | 31C509E705324D7A9D2B9928C92E53AD@desktop обсуждение исходный текст |
Ответ на | Old/New ("Bob Pawley" <rjpawley@shaw.ca>) |
Ответы |
Re: Old/New
|
Список | pgsql-general |
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 ----- Original Message ----- From: "Adrian Klaver" <adrian.klaver@gmail.com> To: "Tom Lane" <tgl@sss.pgh.pa.us> Cc: "Bob Pawley" <rjpawley@shaw.ca>; "Postgresql" <pgsql-general@postgresql.org> Sent: Friday, January 22, 2010 3:01 PM Subject: Re: [GENERAL] Old/New > On Friday 22 January 2010 2:05:02 pm Tom Lane wrote: >> "Bob Pawley" <rjpawley@shaw.ca> writes: >> > Instead I get two identical rows inserted containing the fluid_id = >> > '3501' and 'Pump #1'. >> >> Seems like the only way that's possible with the INSERT .. VALUES >> formulation is if the trigger function gets executed twice. Maybe you >> accidentally created two instances of the trigger? psql's \d on the >> table should list the triggers for you. >> >> regards, tom lane > > In addition to the above, is there more to the trigger function then what > you > have shown so far? > > -- > 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
В списке pgsql-general по дате отправления: