Skip site navigation (1) Skip section navigation (2)

Re: SSI patch version 8

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: Anssi Kääriäinen <anssi(dot)kaariainen(at)thl(dot)fi>
Cc: "Dan Ports" <drkp(at)csail(dot)mit(dot)edu>, "john(dot)okite(at)gmail(dot)org" <john(dot)okite(at)gmail(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SSI patch version 8
Date: 2011-01-14 00:21:43
Message-ID: 4D2F42B7020000250003951E@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: David E. WheelerDate: 2011-01-14 00:22:31
Subject: Re: arrays as pl/perl input arguments [PATCH]
Previous:From: Stephen J. ButlerDate: 2011-01-14 00:15:29
Subject: Re: arrays as pl/perl input arguments [PATCH]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group