Re: Postgres: Transaction Connections

От:

John R Pierce <pierce@hogranch.com>

Дата:

6 мая 2009 г. в 02:33:47

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.

Postgres: Transaction Connections

От:

CM J <postgres.newbie@gmail.com>

Дата:

6 мая 2009 г. в 01:56:23

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.

Re: Postgres: Transaction Connections

От:

Thomas Kellerer <spam_eater@gmx.net>

Дата:

6 мая 2009 г. в 03:42:14

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