Re: Simple question on SELECT - Mailing list pgsql-general

From Richard Broersma
Subject Re: Simple question on SELECT
Date
Msg-id CABvLTWFLUuBgbDaNo48=Uej=K_4P_WF7uFeNCq9KpzgFVShaig@mail.gmail.com
Whole thread Raw
In response to Re: Simple question on SELECT  (Edson Richter <richter@simkorp.com.br>)
List pgsql-general
On Mon, Nov 7, 2011 at 3:30 PM, Edson Richter <richter@simkorp.com.br> wrote:
> Thanks for the fast answer. Is there any way to avoid that? I mean, in MS
> SQL Server, I do have "with no_lock" (that produces dirty reads)?
> Or the way to go is the transaction isolation level?

The lowest level of Isolation supported by PostgreSQL is READ
COMMITTED which is the default transaction isolation level:
http://www.postgresql.org/docs/9.1/interactive/sql-set-transaction.html


--
Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Simple question on SELECT
Next
From: John R Pierce
Date:
Subject: Re: Simple question on SELECT