triggered data change violation

From: Cedar Cox <cedarc(at)visionforisrael(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: triggered data change violation
Date: 2001-01-17 16:53:18
Message-ID: Pine.LNX.4.21.0101171845280.28982-100000@nanu.visionforisrael.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


ERROR: triggered data change violation on relation "tblblah"

This is probably normal, but it just surprised me. I'm not sure if this
is in the documentation. A pl/pgsql trigger tried to DELETE the record
that fired it (AFTER UPDATE, not BEFORE). Comments? Can anyone clarify
why this is so?

-Cedar

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ross J. Reedstrom 2001-01-17 17:14:26 Re: outer join in PostgreSql
Previous Message Thierry Dart 2001-01-17 11:37:23 Number of rows in a ResultSet ?