triggered data change violation

From: Cedar Cox <cedarc(at)visionforisrael(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: triggered data change violation
Date: 2001-03-20 21:13:14
Message-ID: Pine.LNX.4.21.0103202311430.27234-100000@nanu.visionforisrael.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql


Added note: The trigger is a BEFORE trigger.

---------- Forwarded message ----------
To: pgsql-interfaces(at)postgresql(dot)org
Date: Tue, 20 Mar 2001 20:43:59 +0200 (IST)
Subject: triggered data change violation

ERROR: triggered data change violation on relation "tblstsc2options"

What is this? It doesn't happen unless I'm in a transaction. I'm
INSERTing a record and then DELETEing it (in the same transaction) and on
delete I get this error. If I commit and begin a new transaction before
the delete everything is fine. Is it something my trigger causing? I
don't have any UPDATE, INSERT, or DELETE statements in my trigger (and I
am returning old on delete).

Thanks,
-Cedar

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-03-20 21:13:30 Re: Performance monitor signal handler
Previous Message Tom Lane 2001-03-20 21:10:21 Re: Final Call: RC1 about to go out the door ...

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-03-20 21:13:35 Re: [HACKERS] triggered data change violation
Previous Message Tom Lane 2001-03-20 20:39:53 Re: [HACKERS] triggered data change violation