Re: transaction processing after error in statement - Mailing list pgsql-sql

From Jan Wieck
Subject Re: transaction processing after error in statement
Date
Msg-id 3FB2A37A.6060201@Yahoo.com
Whole thread Raw
In response to Re: transaction processing after error in statement  (Holger Jakobs <holger@jakobs.com>)
List pgsql-sql
Holger Jakobs wrote:

> Calling a procedure is a statement as well, and it includes all other
> procedures called from this procedure. So the statement level is always
> the statements that were carried out directly in the transaction. If
> anything within one statement fails, the statement was not carried out
> and must not have any effect. It is not important whether the procedure
> was fired by a trigger or called by another procedure.

So you define the smalles unit being one single statement as issued by 
the client application and receiving one single returncode over the 
frontend/backend protocol.

That's almost what people think of as subtransactions. I think if we 
ever implement them, we will have some session setting that lets the 
backend behave like that and your needs will be satisfied.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-sql by date:

Previous
From: "Damon Chong"
Date:
Subject: Re: How to know column constraints via system catalog tables
Next
From: "George Weaver"
Date:
Subject: Looks are important