Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Issue with insert
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>
- Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: Issue with insert
- Date: Sat, 27 Feb 2010 15:58:20 -0500
- Message-id: <614.1267304300@sss.pgh.pa.us> <text/plain>
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
- Follow-Ups:
- Re: Issue with insert
- From: Michael Gould
- Re: Issue with insert
- References:
- Re: Issue with insert
- From: Michael Gould
- Re: Issue with insert
- Prev by Date: Re: Issue with insert
- Next by Date: Re: Issue with insert
- Previous by thread: Re: Issue with insert
- Next by thread: Re: Issue with insert
- Indexes: