Tom Lane wrote:
>"Stephen R. van den Berg" <[email protected]> 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!"
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
