Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction and cascade problem - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Transaction and cascade problem
Date
Msg-id GNELIHDDFBOCMGBFGEFOMEOCCAAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Transaction and cascade problem  ("Josh Berkus" <josh@agliodbs.com>)
Responses NULL values or not?
List pgsql-sql
Tree view 
> > ERROR: triggered data change violation on relation "groups"
> 
> Yes.  For some technical reason ( I'm not clear on this ) you cannot
> both add and delete the same row within a PostgreSQL transaction.  This
> is a known issue in 7.1.x; I do not know if it is fixed in 7.2.  

Hmmm...I seem to recall that it is fixed in 7.2.  Correct me if I'm wrong.

Chris

pgsql-sql by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: subselects
Next
From: Archibald Zimonyi
Date:
Subject: NULL values or not?