From: | Fran G <poupou1980(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Serializable Isolation Level |
Date: | 2017-05-25 00:37:18 |
Message-ID: | CADiJeWSYC0+NFiYEqmqzS9BKdBw8mujqT8vTUPb+-xsRe1fzCg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi all,
I am getting an exception in my code which I did not anticipate and could
not find sufficient documentation to clear this issue. I have a rather
simple table (Table_A) with two columns (Text id, Integer number). If I do
the following set of commands on two separate psql consoles, I get a
read/write exception.
T1: begin transaction isolation level serializable;
T2: begin transaction isolation level serializable;
T1: update Table_A set number = 1 where id = 'ID1';
T2: update Table_A set number = 1 where id = 'ID2';
T1: commit;
T2: commit;
T2 throws a 40001 exception. Note that both transactions operate on
distinct rows in my table. Then why am I getting an exception? I would
greatly appreciate any pointers.
Thanks,
Fran.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-05-25 00:45:17 | Re: Serializable Isolation Level |
Previous Message | Tom Lane | 2017-05-19 14:53:35 | Re: array_agg cast issue |