On Fri, 19 Sep 2003, Ravi T Ramachandra wrote:
> Here is the table structure. FYI, we tried the experiment with mysql
> and the concurrency is working fine.
>
> create table TABLE1( TABLE_ID IDENTITY NOT NULL ,
> VA_ID SMALLINT NOT NULL,
>
>
using following statement:
UPDATE TABLE1 SET V_VOL = 'ABCD' WHERE TABLE_ID = 10
Regards,
Ravi
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 8:32 PM
To: Ravi T Ramachandra
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Postgre
On Thu, 18 Sep 2003, Ravi T Ramachandra wrote:
>
> Hi,
>
> We are using postgresql 7.3.2 on lunux platform. We performed locking
> test as follows via JDBC:
>
> Started 2 concurrent transaction with autocommit false and isolation
> READ_COMMITTED :
>
> Transaction 1:
> ===
> Update row
Title: Message
Hi,
We are using
postgresql 7.3.2 on lunux platform. We performed locking test as
follows via JDBC:
Started 2 concurrent
transaction with autocommit false and isolation
READ_COMMITTED :
Transaction
1:
===
Update row
1
Sleep for 30
seconds
commit:
Transac