Re: Statement level transactions - Mailing list pgsql-jdbc

From Markus Schaber
Subject Re: Statement level transactions
Date
Msg-id 421F9284.3060008@logi-track.com
Whole thread Raw
In response to Statement level transactions  (Kovács Péter <peter.kovacs@chemaxon.hu>)
List pgsql-jdbc
Hi, Peter,


Kovács Péter schrieb:

> I also remember having read in the new features list for 8.0 the
> introduction of nested transaction. I found no mention to nested
> transactions in the user guides though. Am I missing something?

Savepoints can be used to create nested transactions. For every inner
transaction you want to start, create a savepoint. If you want to commit
or abort that transaction, you release or rollback that savepoint.

Actually, savepoints allow more flexible usage patterns compared to
nested transactions.

HTH,
Markus

--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com


Attachment

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: setFetchSize question
Next
From: Markus Schaber
Date:
Subject: Re: Abandoning PGobject