Skip site navigation (1) Skip section navigation (2)

Re: Updates on updates

From: Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Updates on updates
Date: 2006-01-20 15:56:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
On Thu, Jan 19, 2006 at 05:49:30PM +0200, Shachar Shemesh wrote:
> >But what happens if you lower the transaction isolation level to "read
> >committed"? do the assertions above still hold?
> >
> Dynaset views should remain updated outside of ANY transaction. In any
> case, we do not control the transaction isolation level. We are just a
> driver.

Sorry in advance if I misunderstand you, but a high isolation level
and a dynamic cursor are incompatible with each other. You cannot be
both isolated and aware of every update that's going on at the same
time. So you cannot just let the user enable snapshot isolation if you
want to implement a dynamic cursor.

In response to

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-01-20 16:30:27
Subject: Re: Updates on updates
Previous:From: Campbell, GregDate: 2006-01-20 15:23:07
Subject: Re: Updates on updates

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group