Re: Issue with insert

[Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>]

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