Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 30 Sep 2009 21:02:39 -0400
  • Message-id: <24870.1254358959@sss.pgh.pa.us> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group