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.0103202033230.25524-100000@nanu.visionforisrael.com
Whole thread Raw
Responses Re: triggered data change violation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
Tree view 
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

pgsql-interfaces by date:

Previous
From: Gunnar R|nning
Date:
Subject: Re: [JDBC] Re: PostgreSQL and PHP persistent connections
Next
From: Tom Lane
Date:
Subject: Re: triggered data change violation