Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)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