Re: multicolumn GIST index question

>
> Did anyone get multi-column GIST indexes working using both
> the gist_btree and postgis modules?
It must.

> fl=# -- sessionid is a text; the_geom is a GEOMETRY
> fl=# create index testidx2 on user_point_features using gist
> (sessionid,the_geom);
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> fl=#
> fl=#
> fl=#
> fl=# create table test3(a text, b text, c text);
> CREATE TABLE
> fl=# select addgeometrycolumn ('','test3','the_geom','-1','POINT',2);
> addgeometrycolumn
> --------------------------------------------------------------------------
> public.test3.the_geom SRID:-1 TYPE:POINT DIMS:2
> geometry_column fixed:0
> (1 row)
> fl=# create index idx_text_text on test3 using gist (a,b);
> CREATE INDEX
> fl=# create index idx_text_geom on test3 using gist (a,the_geom);
> CREATE INDEX
> fl=#

Is a sessionid from user_point_features table unique?

Pls, try to compile database with --enable-cassert --enable-debug and send gdb
output.

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/