Re: [JDBC] [BUGS] Problem with Serializable transactions

2004-03-26 Thread Oliver Jowett
Tom Lane wrote: "Robert Green" <[EMAIL PROTECTED]> writes: I have noticed that using postgresql 7.4.2 at serializable level it is possible for two users to update the database at the same time. I ran your test program here and tracked down what the problem is. What's happening is that the JDBC d

Re: [JDBC] [BUGS] Problem with Serializable transactions

2004-03-25 Thread Tom Lane
Oliver Jowett <[EMAIL PROTECTED]> writes: > What do we do if setTransactionIsolation() is called halfway through a > transaction? You can't change the isolation status of an already-started transaction (both Postgres and the SQL spec agree on this). So to the extent that the user expects this to

Re: [BUGS] Problem with Serializable transactions

2004-03-25 Thread Tom Lane
"Robert Green" <[EMAIL PROTECTED]> writes: > I have noticed that using postgresql 7.4.2 at serializable level it is > possible for two users to update the database at the same time. I ran your test program here and tracked down what the problem is. What's happening is that the JDBC driver is issui

[BUGS] Problem with Serializable transactions

2004-03-25 Thread Robert Green
Name: Rob Green e-mail: [EMAIL PROTECTED] PostgreSQL version: 7.4.2 Java version: 1.4.1.03 Operating System: HP-UX 11.00 Host Machine: HP N4000-44 (Quad processor) Short Description: Serializable Transactions don't work as well as they did in postgresql 7.3.3. I am evaluating tran