Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 34E3D634099 for ; Sat, 27 Feb 2010 17:02:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26600-08 for ; Sat, 27 Feb 2010 21:02:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from serv01.siteground178.com (ns1.siteground178.com [67.15.255.19]) by mail.postgresql.org (Postfix) with ESMTP id CEC9D633651 for ; Sat, 27 Feb 2010 17:02:10 -0400 (AST) Received: from [67.15.255.19] (port=37551 helo=intermodalsoftwaresolutions.net) by serv01.siteground178.com with esmtpa (Exim 4.69) (envelope-from ) id 1NlTna-0004ux-Er; Sat, 27 Feb 2010 15:02:06 -0600 Received: from phpmailer ([76.106.235.204]) by intermodalsoftwaresolutions.net with HTTP (PHPMailer); Sat, 27 Feb 2010 15:02:06 -0600 Date: Sat, 27 Feb 2010 15:02:06 -0600 To: Tom Lane Cc: Scott Marlowe , pgsql-sql@postgresql.org From: Michael Gould Subject: Re: Issue with insert Message-ID: X-Priority: 3 X-Mailer: PHPMailer [version 1.71] X-Mailer: FeLaMiMail In-Reply-To: <614.1267304300@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - serv01.siteground178.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - intermodalsoftwaresolutions.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/108 X-Sequence-Number: 33707 Tom, Thanks, that's exactly what it was. Best Regards Mike Gould "Tom Lane" wrote: > Michael Gould writes: >> Here is the table DDL, >=20 > Can't really test this since you didn't supply the source code for > those triggers: >=20 >> CREATE TRIGGER "insertcitystateinfo" BEFORE INSERT OR UPDATE >> ON "iss"."citystateinfo" FOR EACH ROW >> EXECUTE PROCEDURE "iss"."insertcitystateinfofunc"(); >=20 >> CREATE TRIGGER "update_timestamp_citystateinfo" BEFORE UPDATE >> ON "iss"."citystateinfo" FOR EACH ROW >> EXECUTE PROCEDURE "iss"."timestampfunc"(); >=20 > Personally I'm suspicious that the BEFORE INSERT trigger is changing the > data. >=20 > regards, tom lane >=20 -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax