[postgis-users] Postgres 8.0beta1 crashes when SELECTing using GISTindex?

[Dan R Greening]

The immediately following script (taken directly from
http://postgis.refractions.net/README.postgis.txt) also causes a crash in
the PostgreSQL 8.0beta1

  CREATE TABLE geom_test ( gid int4, geom geometry,name varchar(25) );
  INSERT INTO geom_test ( gid, geom, name ) 
    VALUES ( 1, 'POLYGON((0 0 0,0 5 0,5 5 0,5 0 0,0 0 0))', '3D Square');
  INSERT INTO geom_test ( gid, geom, name ) 
    VALUES ( 2, 'LINESTRING(1 1 1,5 5 5,7 7 5)', '3D Line' );
  INSERT INTO geom_test ( gid, geom, name )
    VALUES ( 3, 'MULTIPOINT(3 4,8 9)', '2D Aggregate Point' );
  SELECT * from geom_test WHERE geom && 'BOX3D(2 2 0,3 3 0)'::box3d;

Are others getting this to work OK?  (In other words, should I suspect a bad
installation?)

Dan Greening, Ph.D.  CEO BigTribe http://dan.greening.name/contact.htm 
 

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Dan R Greening
> Sent: Sunday, August 15, 2004 8:28 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Postgres 8.0beta1 crashes when 
> SELECTing using GISTindex?
> 
> The following test SQL script crashes Postgres (the server) 
> under the Postgres 8.0beta1 Windows-installer plus PostGIS 
> windows installer.  I suspect it might actually be me using 
> something I shouldn't, but could you take a peek?  Yes, I 
> loaded postgis.sql.
> 
> The crash occurs in the SELECT statement at the end.
> 
> ---------------
> CREATE TABLE poiloc (
>   poiid varchar(11) NOT NULL UNIQUE,
>   latitude DOUBLE PRECISION NOT NULL,
>   longitude DOUBLE PRECISION NOT NULL,
>   PRIMARY KEY  (poiid)
> );
> CREATE INDEX lat_index ON poiloc (latitude,longitude); CREATE 
> INDEX lon_index ON poiloc (longitude,latitude); INSERT INTO 
> poiloc (poiid, latitude, longitude) VALUES 
> ('27165',37.766029,-122.430382); INSERT INTO poiloc (poiid, 
> latitude, longitude) VALUES ('11',37.764894,-122.423022); 
> INSERT INTO poiloc (poiid, latitude, longitude) VALUES 
> ('12',37.764829,-122.423882); INSERT INTO poiloc (poiid, 
> latitude, longitude) VALUES ('18',37.762529,-122.396481); 
> INSERT INTO poiloc (poiid, latitude, longitude) VALUES 
> ('19',37.761829,-122.418282); INSERT INTO poiloc (poiid, 
> latitude, longitude) VALUES ('25',37.790508,-122.398332); 
> INSERT INTO poiloc (poiid, latitude, longitude) VALUES 
> ('26',37.788028,-122.395281); SELECT 
> AddGeometryColumn('poi','poiloc','geom',-1,'POINT', 2); 
> UPDATE poiloc set geom = GeometryFromText('POINT(' || 
> latitude || ' ' || longitude || ')',
>     -1);
> CREATE INDEX geom_idx ON poiloc USING GIST(geom 
> gist_geometry_ops); select poiid from poiloc where geom && 
> GeometryFromText('BOX3D(37.76930
> -122.40798,37.78729 -122.38521)',-1);
> -------------------------
> 
> Dan Greening, Ph.D.  CEO BigTribe 
> http://dan.greening.name/contact.htm 
>  
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
> > postgis-users-request at postgis.refractions.net
> > Sent: Sunday, August 15, 2004 8:09 AM
> > To: greening at bigtribe.com
> > Subject: Welcome to the "postgis-users" mailing list
> > 
> > Welcome to the postgis-users at postgis.refractions.net mailing list!
> > 
> > To post to this list, send your email to:
> > 
> >   postgis-users at postgis.refractions.net
> > 
> > General information about the mailing list is at:
> > 
> >   http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> > If you ever want to unsubscribe or change your options (eg, 
> switch to 
> > or from digest mode, change your password, etc.), visit your 
> > subscription page at:
> > 
> >   
> > http://postgis.refractions.net/mailman/options/postgis-users/g
> > reening%40bigtribe.com
> > 
> > 
> > You can also make such adjustments via email by sending a 
> message to:
> > 
> >   postgis-users-request at postgis.refractions.net
> > 
> > with the word `help' in the subject or body (don't include the 
> > quotes), and you will get back a message with instructions.
> > 
> > You must know your password to change your options 
> (including changing 
> > the password, itself) or to unsubscribe.  It is:
> > 
> >   thingy
> > 
> > Normally, Mailman will remind you of your postgis.refractions.net 
> > mailing list passwords once every month, although you can 
> disable this 
> > if you prefer.  This reminder will also include 
> instructions on how to 
> > unsubscribe or change your account options.  There is also 
> a button on 
> > your options page that will email your current password to you.
> > 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>