On Friday 22 January 2010 2:05:02 pm Tom Lane wrote: > "Bob Pawley" <rjpawley@xxxxxxx> 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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
