Tom, Thanks, that's exactly what it was.
Best Regards Mike Gould "Tom Lane" <t...@sss.pgh.pa.us> wrote: > Michael Gould <mgo...@intermodalsoftwaresolutions.net> writes: >> Here is the table DDL, > > Can't really test this since you didn't supply the source code for > those triggers: > >> CREATE TRIGGER "insertcitystateinfo" BEFORE INSERT OR UPDATE >> ON "iss"."citystateinfo" FOR EACH ROW >> EXECUTE PROCEDURE "iss"."insertcitystateinfofunc"(); > >> CREATE TRIGGER "update_timestamp_citystateinfo" BEFORE UPDATE >> ON "iss"."citystateinfo" FOR EACH ROW >> EXECUTE PROCEDURE "iss"."timestampfunc"(); > > Personally I'm suspicious that the BEFORE INSERT trigger is changing the > data. > > regards, tom lane > -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql