From: | "tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org>, "Tapin Agarwal" <tapin(dot)agarwal(at)globallogic(dot)com> |
Subject: | Re: "attempted to lock invisible tuple" error while update |
Date: | 2010-07-14 08:14:32 |
Message-ID: | 68666423656E1444A011106C4E085F4DD48D1F@ex3-del1.synapse.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Scott
I looked into the release notes of 8.4.2 and found the following fix in
the fix list for 8.4.2 :
------------------------------------------------------------------------
----
Ensure that a cursor's snapshot is not modified after it is created
(Alvaro)
This could lead to a cursor delivering wrong results if later operations
in the same transaction modify the data the cursor is supposed to
return.
------------------------------------------------------------------------
----
The same fix is not included in fix list for postgres-8.1.19 which came
at the same time when postgres-8.4.2 was released i.e 14th Dec.,2009.
Its not there in any of the 8.1 releases after that i.e 8.1.20 and 21.
So , it seems that this fix is not included in 8.1. Do you have any
idea what could be the reason.
Thanks..
Tamanna
-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Tuesday, July 13, 2010 1:14 PM
To: tamanna madaan
Cc: pgsql-general(at)postgresql(dot)org; Tapin Agarwal
Subject: Re: [GENERAL] "attempted to lock invisible tuple" error while
update
On Mon, Jul 12, 2010 at 11:54 PM, tamanna madaan
<tamanna(dot)madan(at)globallogic(dot)com> wrote:
> Hi Scott
>
> Thanks for your reply . I haven't yet tried updating to latest 8.1.x
version. Was juss googling about this error and came across
> a link discussing the same issue :
>
>
http://groups.google.com/group/pgsql.general/browse_thread/thread/75df15
648bcb502b/10232d1f183a640a?lnk=raot
>
> In this , the problem had occurred on 8.4.1 and a patch
(snapmgr-bugfix-rehash-2.patch ) was provided on 8.4.1 to circumvent
this problem.
>
> This patch worked fine . I was just wondering if this patch
> is backward compatible and can it be merged with 8.1.2
> to get it working. Any suggestions ??
Check the release notes for the 8.1 version that came our around the
same time as 8.4.2? I'd expect if it's a known issue that affected
all versions the fix got put into the older versions as well, unless
it was considered a more dangerous thing to fix there.
From | Date | Subject | |
---|---|---|---|
Next Message | Davor J. | 2010-07-14 08:55:11 | Re: Extending postgres objects with attributes |
Previous Message | Andras Fabian | 2010-07-14 07:18:49 | Re: PG_DUMP very slow because of STDOUT ?? |