Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: psql commit

Re: psql commit

From: <frank.van.bortel_at_gmail.com>
Date: 6 Mar 2006 06:30:11 -0800
Message-ID: <1141655411.111283.255210@i39g2000cwa.googlegroups.com>


Uncommitted transactions get committed when exiting, as Jim pointed out.
He also pointed out you should not rely on this, and explicitly code commit (and/or rollback).

So, if something weird happens (define weird...) and you session exists with an error condition, it does not get committed. You probably want these conditions captured in an exception handler.

Frank van Bortel Received on Mon Mar 06 2006 - 08:30:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US