Hi, all,
I start two session with the following execute time order:
session1: START TRANSACTION ISOLATION LEVEL SERIALIZABLE;
session2: INSERT INTO t1 values(1);
session2: COMMIT;
session1: SELECT * FROM t1;
I found session1 got the value 1 which is inserted by session2.
Is there any way to make session1 not see the value session2 inserted？
For mysql, I know there is a syntax:
START TRANSACTION WITH CONSISTENT SNAPSHOT.
I search the PG START syntax, but found none.
Any idea will be appreciated!