Postgres: Transaction Connections

CM J wrote:

Hi ,

I use postgres database server 8.2.12 with my java
application. I was wondering if postgres supports transactions by
default or do i have to turn some parameter on to enable transaction
support ?

Postgres supports transactions by default.

Postgres JDBC drivers for Java have two operating modes, autocommit
where every statement is its own transaction, and non-autocommit, where
you have to explicitly commit or rollback to end a transaction.

John R Pierce, 06.05.2009 07:33:

I use postgres database server 8.2.12 with my java
application. I was wondering if postgres supports transactions by
default or do i have to turn some parameter on to enable transaction
support ?

Postgres supports transactions by default.

Actually - as with any other sensible RDBMS - you can *not* turn them off.

Thomas