On 17 March 2016 at 21:15, Kevin Grittner <kgri...@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 odsjfiojdsif ojdsiof 112 | 9 | hellofji djf odsjfiojdsif ojdsiof 115 | 6 | hellofji djf odsjfiojdsif ojdsiof 119 | 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
