Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: psql commit
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