Anssi Kääriäinen<anssi(dot)kaariainen(at)thl(dot)fi> wrote:
> I think I found a problem. This is using SSI v8. The table
> definition:
>
> create table test_t (id integer, val1 text, val2 integer);
> create index test_idx on test_t(id) where val2 = 1;
> insert into test_t (select generate_series(0, 10000), 'a', 2);
> insert into test_t (select generate_series(0, 10), 'a', 1);
> T1:
> hot2=> begin transaction isolation level serializable;
> hot2=> select * from test_t where val2 = 1;
> hot2=> update test_t set val2 = 2 where val2 = 1 and id = 10;
> T2:
> hot2=> begin transaction isolation level serializable;
> hot2=> select * from test_t where val2 = 1;
> hot2=> update test_t set val2 = 2 where val2 = 1 and id = 9;
> hot2=> commit;
> T1:
> hot2=> commit;
I hope you have no objection to having the code you wrote included
in the test suite which is part of the patch. Well, if you do, I'll
pull it back out and invent something similar... ;-)
http://git.postgresql.org/gitweb?p=users/kgrittn/postgres.git;a=commitdiff;h=2502cccbdd5e5d44be469549b91fe49c0554ec3e
-Kevin