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