Re: Weird behavior with "sensitive" cursors.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Daniel F <dbf13db(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Weird behavior with "sensitive" cursors.
Date: 2009-10-01 01:02:39
Message-ID: 24870.1254358959@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-10-01 01:26:11 Re: Weird behavior with "sensitive" cursors.
Previous Message Alvaro Herrera 2009-10-01 00:35:34 Re: Weird behavior with "sensitive" cursors.