[Info-ingres] ANSI + MVCC

Alex Hanshaw Alex.Hanshaw at actian.com
Thu Oct 22 13:08:41 UTC 2015


If you're using MVCC you should leave the lock isolation levels alone. The majority of bugs found with MVCC relate to people changing the underlying lock isolation levels.
If your application is written with MVCC in mind you should not need to tinker with the lock isolation levels anyway.

 Alex

-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org [mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of mike_cu80 at yahoo.com
Sent: 22 October 2015 12:14
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] ANSI + MVCC

Can you mix ANSI sessions with MVCC ones?

For example, one session issuing 
SET TRANSACTION/SESSION ISOLATION MVCC
and the other
SET TRANSACTION/SESSION ISOLATION REPEATABLE READ

isn't there conflict?

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres




More information about the Info-ingres mailing list