Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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 22:12:42 -0400
- Message-id: <4521.1254363162@sss.pgh.pa.us> <text/plain>
Alvaro Herrera <alvherre(at)commandprompt(dot)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
- References:
- Weird behavior with "sensitive" cursors.
- From: Daniel F
- Re: Weird behavior with "sensitive" cursors.
- From: Alvaro Herrera
- Re: Weird behavior with "sensitive" cursors.
- From: Tom Lane
- Re: Weird behavior with "sensitive" cursors.
- From: Alvaro Herrera
- Re: Weird behavior with "sensitive" cursors.
- From: Tom Lane
- Re: Weird behavior with "sensitive" cursors.
- From: Alvaro Herrera
- Weird behavior with "sensitive" cursors.
- Prev by Date: Re: Weird behavior with "sensitive" cursors.
- Previous by thread: Re: Weird behavior with "sensitive" cursors.
- Next by thread: I can not drop a user/role because an object depent on it.
- Indexes: