Postgres Pro
Downloads
Home   >   mailing lists

Re: Crash when inserting gist records, or creating index on ( int, geom ) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Crash when inserting gist records, or creating index on ( int, geom )
Date
Msg-id 12683.1107412323@sss.pgh.pa.us
Whole thread Raw
In response to Crash when inserting gist records, or creating index on ( int, geom )  (Robin Chauhan <robin.chauhan@gmail.com>)
List pgsql-hackers
Tree view 
Robin Chauhan <robin.chauhan@gmail.com> writes:
> I installed PostGIS, which appeared to work just fine.  The I
> installed contrib/btree_gist, and since then I've had issues.

> PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66

> Would you have any advice for me?

Try a more modern Postgres.  I note in the CVS logs bug fixes for NULLs
in gist indexes as recently as 7.4.6.

If you can reproduce this on 7.4.7 or 8.0 then I'd be interested to look
at a test case ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Martin Pitt
Date:
Subject: Re: libpq API incompatibility between 7.4 and 8.0
Next
From: Tom Lane
Date:
Subject: Re: fatal: cache id 30 (or alike)