Re: Issue with insert

Tom,

Thanks, that's exactly what it was.

Best Regards

Mike Gould

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>

--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax