On 17 March 2016 at 21:15, Kevin Grittner <kgrittn@gmail.com> wrote:
> New patch just to merge in recent commits -- it was starting to
> show some bit-rot. Tests folded in with main patch.
In session 1, I've run:
# begin transaction isolation level repeatable read ;
BEGIN
*# declare stuff scroll cursor for select * from test where num between 5 and 9;
DECLARE CURSOR
*# fetch forward 5 from stuff;id | num | thing
-----+-----+------------------------------------ 2 | 8 | hellofji djf odsjfiojdsif ojdsiof 3 | 7 | hellofji djf
odsjfiojdsifojdsiof112 | 9 | hellofji djf odsjfiojdsif ojdsiof115 | 6 | hellofji djf odsjfiojdsif ojdsiof119 | 8
|hellofji djf odsjfiojdsif ojdsiof
(5 rows)
In session 2, over a min later:
# update test set num = 12 where num between 5 and 9 and id between 120 and 250;
ERROR: snapshot too old
Then back to session 1:
*# fetch forward 5 from stuff;
ERROR: snapshot too old
Should session 2 be getting that error?
Thom