Re: [postgis-devel] RE: BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently - Mailing list pgsql-bugs

From Paul Ramsey
Subject Re: [postgis-devel] RE: BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently
Date
Msg-id 30fe546d0812081102q53f5ff58of75d74b8ea5c13c@mail.gmail.com
Whole thread Raw
In response to Re: BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently  ("Obe, Regina" <robe.dnd@cityofboston.gov>)
List pgsql-bugs
Yes, that patch removes the bug.

P.

On Sun, Dec 7, 2008 at 11:51 PM, Obe, Regina <robe.dnd@cityofboston.gov> wrote:
> "Regina Obe" <robe.dnd@cityofboston.gov> writes:
>> Description:        Clustering on GIST INDEX clobbers records in table
>> intermittently
>
>> This doesn't always happen to me but does intermittently, and for others
>> it
>> happens all the time.
>
>> I wonder whether this is fixed by this recent patch:
>> http://archives.postgresql.org/pgsql-committers/2008-12/msg00053.php
>
>> The pre-patch behavior would've depended on the value of a
>> never-initialized struct field, so the erratic behavior is explained
>> by varying contents of memory.  I'm unable to make it happen in an
>> assert-enabled build, but that's probably because the initial contents
>> of a palloc'd chunk are never zeroes in such a build.
>
>>                       regards, tom lane
>
> Tom,
>
> Thanks for the quick response on this.
>
> Paul,
> You think by chance you can test out the patch since you can make this bug
> happen consistently on your build.
>
> Thanks,
> Regina
>
>
>
> ________________________________
>
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure pursuant to
> Massachusetts law. It is intended solely for the addressee. If you received
> this in error, please contact the sender and delete the material from any
> computer.
>
> ________________________________
>
> Help make the earth a greener place. If at all possible resist printing this
> email and join us in saving paper.
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
>

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4574: LIKE fails on non-varying character with no wildcards
Next
From: "Alexander Gallardo Torres"
Date:
Subject: download PostgreSQL 8.0.2