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
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
"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
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