Postgres Pro
Downloads
Home   >   mailing lists

triggered data change violation - Mailing list pgsql-interfaces

From Cedar Cox
Subject triggered data change violation
Date
Msg-id Pine.LNX.4.21.0101171845280.28982-100000@nanu.visionforisrael.com
Whole thread Raw
List pgsql-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: outer join in PostgreSql
Next
From: "David Zoll"
Date:
Subject: Re: How do I install PostgreSQL ODBC Drivers for Windows from Source?