Re: READ-COMMITTED does not behave as expected

2002-12-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Horst Scheruga wrote: If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection. As of my understanding

re: READ-COMMITTED does not behave as expected

2002-12-12 Thread Victoria Reznichenko
On Thursday 12 December 2002 11:23, Horst Scheruga wrote: > If I use the transaction isolation level of READ-COMMITTED, > I have the problems that I do not see changes to the table made > within another connection (and commited) until I call commit in my > connection. > > As of my understanding

READ-COMMITTED does not behave as expected

2002-12-12 Thread Horst Scheruga
If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection.   As of my understanding this behaviour is correct for the REPEATABLE-READ and SERIALIZABLE is