From: Michael Gould <mgould@intermodalsoftwaresolutions.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Issue with insert
Date: Sat, 27 Feb 2010 15:02:06 -0600
Message-ID: <e58f6475e92a90670fcc7e02d518f099@intermodalsoftwaresolutions.net> (raw)
In-Reply-To: <614.1267304300@sss.pgh.pa.us>
Tom,
Thanks, that's exactly what it was.
Best Regards
Mike Gould
"Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> 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
>
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mgould@intermodalsoftwaresolutions.net, tgl@sss.pgh.pa.us, scott.marlowe@gmail.com
Subject: Re: Issue with insert
In-Reply-To: <e58f6475e92a90670fcc7e02d518f099@intermodalsoftwaresolutions.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox