Re: Issue with insert

Michael Gould <mgould@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