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