[postgis-users] Crash when creating index on ( int, geom )

[Mark Cave-Ayland]

Hi Robin,

If you're ok working with source code then I would also compile and use the
latest 7.3 release which is currently 7.3.8 with --enable-debug. Create a
fresh database cluster with initdb, load your data, and try again. If it
still fails then it's fairly certain to be a bug, perhaps something subtle
in the PostGIS indexing code or with btree_gist. The backtrace should give
us more information on this.


Kind regards,

Mark.

------------------------
WebBased Ltd
South West Technology Centre
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 791021
F: +44 (0)1752 791023
W: http://www.webbased.co.uk
 

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Robin Chauhan
> Sent: 21 January 2005 17:23
> To: Mark Cave-Ayland; PostGIS Users Discussion
> Subject: Re: [postgis-users] Crash when creating index on ( 
> int, geom )
> 
> 
> Mark,
> 
> I tried duplicating the table and got the same reuslt with 
> the new table.  Thanks for your instructions on getting a 
> backtrace using gdb.
> 
> Before I tried that, I also attempted to install a more 
> updated version of btree_gist from here:
>    
> http://www.sai.msu.su/~megera/postgres/gist/btree_gist/btree_g
> ist-7.4.tar.gz
> 
> ...which in the README says it can work on postgres 7.3 and 
> up (I have 7.3.2).  Unfortunately I was not able compile it:
> 
> btree_common.c: In function `gbtreekey_in':
> btree_common.c:18: warning: implicit declaration of function `ereport'
> btree_common.c:19: warning: implicit declaration of function `errcode'
> btree_common.c:19: `ERRCODE_FEATURE_NOT_SUPPORTED' undeclared 
> (first use in this function)
> btree_common.c:19: (Each undeclared identifier is reported only once
> btree_common.c:19: for each function it appears in.)
> btree_common.c:20: warning: implicit declaration of function `errmsg'
> btree_common.c: In function `gbtreekey_out':
> btree_common.c:29: `ERRCODE_FEATURE_NOT_SUPPORTED' undeclared 
> (first use in this function)
> make: *** [btree_common.o] Error 1
> 
> For now I am using the separate indexes as suggested by 
> Markus which is working very well, but I will try to track 
> this down further.
> 
> -Robin