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

From Tom Lane
Subject Re: Weird behavior with "sensitive" cursors.
Date
Msg-id 24870.1254358959@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.
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane escribi�:
>> I think we need to ensure that when a cursor is created, it obtains a
>> private copy of the current snapshot ... but I'm not sure where that
>> ought to happen.  Thoughts?

> Maybe you are right, but I don't think that's the only bug here.

Well, the first problem is that 8.4 is failing to duplicate the
historical behavior.  After that we can think about whether we'd like to
change the historical behavior.  I'm not entirely convinced about that
yet (and it certainly wouldn't be something I'd want to back-patch).

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Weird behavior with "sensitive" cursors.
Next
From: Alvaro Herrera
Date:
Subject: Re: Weird behavior with "sensitive" cursors.