Обсуждение: Transaction Isolation - read uncommitted

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

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 <rene@lab.applinet.nl>