| 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: | Whole Thread | Raw Message | 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 |