unknown error message

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: unknown error message
Date: 2006-07-24 16:21:38
Message-ID: ea2s0k$35a$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm getting the following error from my python script, which tries to
insert lots of data in one transaction:

libpq.OperationalError: ERROR: failed to fetch new tuple for AFTER trigger

I have several AFTER triggers in place, which one raises this error? I'm
sure I only INSERT data, no UPDATE nor DELETE, so for what reason could
a trigger fail to fetch a new tuple? Can deferred constraints raise such
errors? Because AFAICT no triggers should be invoked by the very SQL
command which causes the error... strange enough!

Any hints on where to look for the bug?

I'm on a PostgreSQL 8.2devel snapshop from 06/06/2006 (silly date :-)
using PL/Python for triggers. I'm unable to paste the schema - plus it's
quite large and - as said - I have no clue what part of it raises the error.

Thanks for you help.

Regards

Markus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Theodore H. Smith 2006-07-24 16:57:52 Re: Why can't I connect to postgres?
Previous Message John DeSoi 2006-07-24 15:46:09 Re: Why can't I connect to postgres?