娄帅 wrote:
> 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.
>
>
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of 娄帅
Sent: Friday, June 26, 2015 9:12 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Question about the isolation level and visible
Hi, all,
I start two session with the following execute
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
