Re: Odd behavior observed - Mailing list pgsql-general

From Marc Evans
Subject Re: Odd behavior observed
Date
Msg-id 20060919132900.I27583@me.softwarehackery.com
Whole thread Raw
In response to Re: Odd behavior observed  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Odd behavior observed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, 19 Sep 2006, Tom Lane wrote:

> Marc Evans <Marc@SoftwareHackery.Com> writes:
>> On Tue, 19 Sep 2006, Tom Lane wrote:
>>> What insert command is being issued exactly, and from what source?  I'm
>>> speculating about issues like stale plans or metadata caches, but you're
>>> not providing any information about where to look.
>
>> Sorry for being terse Tom. Here is the exact commands and responses:
>
> Hmph.  You got any ON INSERT triggers or rules on that table?  I can't
> think of anything else that would interfere with data getting stored.

No INSERT triggers. I do have a BEFORE DELETE trigger, and a pile of
FOREIGN KEY items (which work kinda like an INSERT trigger).

- Marc

pgsql-general by date:

Previous
From: "Jack Orenstein"
Date:
Subject: Re: Initializing Datums for use with SPI_execute_plan
Next
From: "Brandon Aiken"
Date:
Subject: Re: vista