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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-03 06:38:39 Re: fatal: cache id 30 (or alike)
Previous Message Simon Riggs 2005-02-03 06:10:41 LWLock cache line alignment