From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | Zdeněk Jílovec <zdenek(dot)jilovec(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: ERROR - CREATE GIST INDEX on 9.2 beta3 |
Date: | 2012-08-15 06:50:36 |
Message-ID: | 502B46BC.9050202@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 15.08.2012 01:02, Zdeněk Jílovec wrote:
> Hello,
>
> I use PostgreSQL 9.2beta3 with PostGIS 2.0.1 and if I try create GIST index
> on column geometry(Point,2065) I get error:
>
> test=> CREATE INDEX places_point ON places USING GIST(def_point);
> ERROR: failed to re-find parent for block 18097
>
> It works on 9.1
Hmm, I bet this is a bug in the new GiST buffering build code. There was
an earlier bug that led to "failed to re-find parent" errors that I
fixed back in May, but maybe I missed some corner case.
> I can send a table dump (43 MB - bzip2).
Yes, please send the dump to me off-list, and I'll take a look.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | valgog | 2012-08-15 10:10:42 | BUG #7494: WAL replay speed depends heavily on the shared_buffers size |
Previous Message | Craig Ringer | 2012-08-15 01:54:21 | Re: BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows |