Tom Lane wrote:
>"Stephen R. van den Berg" <srb(at)cuci(dot)nl> writes:
>> BEGIN
>> vcsid:=vfrom;
>> LOOP
>> EXIT WHEN vsid IS NOT NULL OR vcsid=vold;
>> END LOOP;
>> RETURN vsid;
>> END;
>And are you certain that's never an infinite loop? The query string
>gives a starting point that one suspects doesn't terminate.
Indeed, you're right. It starts at a deleted item due to a race condition.
Thanks, sorry for the noise.
--
Sincerely,
Stephen R. van den Berg.
"Very funny, Mr. Scott. Now beam down my clothes!"