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
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 ... |
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 |