Skip site navigation (1) Skip section navigation (2)

Re: Crash when inserting gist records, or creating index on ( int, geom )

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robin Chauhan <robin(dot)chauhan(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Crash when inserting gist records, or creating index on ( int, geom )
Date: 2005-02-03 06:32:03
Message-ID: 12683.1107412323@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Robin Chauhan <robin(dot)chauhan(at)gmail(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-02-03 06:38:39
Subject: Re: fatal: cache id 30 (or alike)
Previous:From: Simon RiggsDate: 2005-02-03 06:10:41
Subject: LWLockRelease

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group