Обсуждение: Postgres: Transaction Connections

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 ?

Thanks.

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