Re: [JDBC] Transaction Isolation - read uncommitted

[Rene Pijlman]

On Mon, 27 Aug 2001 15:25:23 -0700, Ralf Reissig wrote:
>I there any support in postgres for reading uncommited data 
>without a read lock ?

No, there isn't. A dirty read is not possible with PostgreSQL.
This is not JDBC specific. See
http://www.postgresql.org/idocs/index.php?sql-set-transaction.html
http://www.postgresql.org/idocs/index.php?transaction-iso.html

Regards,
René Pijlman <[EMAIL PROTECTED]>

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[JDBC] Transaction Isolation - read uncommitted

[Ralf Reissig]

Hi all,

i am trying to find a way reading uncommitted data within a single
transaction, but it seems there is no way 
to do a "TRANSACTION_READ_UNCOMMITTED" on connections in Postgresql as
it works for Oracle or Informix. 
I there any support in postgres for reading uncommited data without a
read lock ? I am currently using JDBC/PostgreSQL 7.1.2 running on Linux. 

Thanks;
Ralf

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster