Re: Weird behavior with "sensitive" cursors. - Mailing list pgsql-general

From Tom Lane
Subject Re: Weird behavior with "sensitive" cursors.
Date
Msg-id 4521.1254363162@sss.pgh.pa.us
Whole thread Raw
In response to Re: Weird behavior with "sensitive" cursors.  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Weird behavior with "sensitive" cursors.
Re: Weird behavior with "sensitive" cursors.
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane escribió:
>> Well, the first problem is that 8.4 is failing to duplicate the
>> historical behavior.

> Oh!  That's easy.

I don't think that testing rowMarks is the right thing at all here.
That tells you whether it's a SELECT FOR UPDATE, but actually we
want any cursor (and only cursors) to have a private snapshot.

Also, do we really need the Register bit?  Won't the portal register
its use of the snapshot anyway (or if it doesn't, isn't that a bug)?

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Weird behavior with "sensitive" cursors.
Next
From: Rakotomandimby Mihamina
Date:
Subject: [OT] Relocation lookup