Statement level transactions

From: Kovács Péter <peter(dot)kovacs(at)chemaxon(dot)hu>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Statement level transactions
Date: 2005-02-25 13:27:49
Message-ID: 421F27D5.4070602@chemaxon.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

With the introduction of checkpoints, it is now possible (or has been
made very easy) to implement behaviour what Oracle calls "statement
level transaction". E.g:

Inserting an already existing value into a column with unique key
constraint throws an exception, but the containing transaction can
continue. I can mimique this behaviour by using checkpoints.

Is there any facility in place (in the JDBC driver or in the backend)
that already does this for me? I.e. is there a config parameter that I
have just to turn on to have statement level transaction behaviour?

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?

Thank you!

Regards,
Peter

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Francisco Figueiredo Jr. 2005-02-25 14:44:48 Re: [JDBC] Where are we on stored procedures?
Previous Message Neil Conway 2005-02-25 06:48:16 Re: Where are we on stored procedures?