Re: Postgresql 8.1 released

>Two-Phase commit (ok, that is gone with PG 8.1),
but the second is a SNAPSHOT / REPEATABLE READ transaction isolation. I can't live without that when it comes having a stable view of data during one transaction, or did that change with 8.1? Is there now a SNAPHOST / REPEATBLE READ transaction isolation level available as well? 

Hi Thomas,
Here is the docs on that for 8.1:

http://www.postgresql.org/docs/8.1/static/transaction-iso.html

Not sure if serialized is the same as repeatable.

later,

Tony
.

Relevant Pages

  • Seeking Testing Volunteers W2K MTS/DTC to VMS DECdtm Distributed 2PC Transactions
    ... Microsoft's Distributed Transaction Coordinator in a Windows2000 ... with any resource manager under the control of DECdtm (e.g. Rdb ... Would you like to talk to VMS with TIER3 Sockets, ... the ACID properties of a true Heterogeneous Two-Phase Commit then you will ...
    (comp.lang.cobol)
  • Seeking Testing Volunteers W2K MTS/DTC to VMS DECdtm Distributed 2PC Transactions
    ... Microsoft's Distributed Transaction Coordinator in a Windows2000 ... with any resource manager under the control of DECdtm (e.g. Rdb ... Would you like to talk to VMS with TIER3 Sockets, ... the ACID properties of a true Heterogeneous Two-Phase Commit then you will ...
    (comp.os.vms)
  • RE: Concurrency problem
    ... which means if one transaction is updating the data ... data source will be locked and waiting for the updating transaction ends. ... Set Transaction Isolation Level to READ UNCOMMITTED ... we need to first turn on the database snapshot setting. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: all about transaction
    ... > confusing:) ... SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ... the second session will wait for session 1 to commit or ...
    (microsoft.public.sqlserver.programming)
  • Re: Any way to get an execution trace out of Access?
    ... If you're doing something like assigning open tasks to users, you may need to run the sql in a transaction with serial isolation. ... The problem appeared to be that the Select subquery would execute "simulataneously" for multiple users, so even if the Update portion were properly controlled, 2 users could be assigned the same task. ... By increasing the transaction isolation level, the Select subquery was forced to be part of the Update transaction. ...
    (microsoft.public.access.formscoding)