Re: Odd behavior observed

From: Marc Evans <Marc(at)SoftwareHackery(dot)Com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Odd behavior observed
Date: 2006-09-19 17:30:06
Message-ID: 20060919132900.I27583@me.softwarehackery.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


On Tue, 19 Sep 2006, Tom Lane wrote:

> Marc Evans <Marc(at)SoftwareHackery(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Aiken 2006-09-19 17:31:02 Re: vista
Previous Message Jack Orenstein 2006-09-19 17:27:56 Re: Initializing Datums for use with SPI_execute_plan

Browse pgsql-hackers by date

  From Date Subject
Next Message Brandon Aiken 2006-09-19 17:31:02 Re: vista
Previous Message Tom Lane 2006-09-19 17:27:48 Re: Odd behavior observed