[postgis-users] Help, What am I missing gist_geometry_ops column???

[Stephen Woodbridge]

Mark and Jan,

Thanks, that was the problem. Seems to be working now.

-Steve

Mark Cave-Ayland wrote:
>>-----Original Message-----
>>From: postgis-users-bounces at postgis.refractions.net 
>>[mailto:postgis-users-bounces at postgis.refractions.net] On 
>>Behalf Of Stephen Woodbridge
>>Sent: 19 July 2005 16:31
>>To: PostGIS Users Discussion
>>Subject: [postgis-users] Help, What am I missing 
>>gist_geometry_ops column???
>>
>>
>>Hi all,
>>
>>I'm try to create a postGIS table in a schema and it is 
>>mostly working, 
>>but I am having trouble building an index.
>>
>>1. loaded the postGIS extensions and spatial references into schema 
>>"public" like normal
>>
>>2. created tables and loaded the data in my own schema like:
>>
>>### Drop the table if it exists
>>echo "DROP TABLE swoodbridge.rgeo;" | psql -U pgsql -h localhost dev
>>
>>### Define the table so we can load data into it
>>FILE=`ls e*/*.shp | head -1`
>>shp2pgsql -p -s 4326 -g the_geom $FILE swoodbridge.rgeo | 
>>psql -U pgsql 
>>-h localhost dev
>>
>>### Append each of the files to the table
>>for FILE in e*/*.shp ; do
>>     shp2pgsql -a -s 4326 -g the_geom $FILE swoodbridge.rgeo 
>>| psql -U 
>>pgsql -h localhost dev
>>done
>>
>>The above all works and looks ok.
>>
>>3. tried to create an index:
>>
>>dev=# create index rgeo_gidx on swoodbridge.rgeo using gist 
>>(the_geom, 
>>gist_geometry_ops);
>>ERROR:  column "gist_geometry_ops" does not exist
>>
>>I seem to have missed a critical step, but not sure what.
>>Any help would be appreciated.
>>
>>-Steve
> 
> 
> 
> Hi Steve,
> 
> I don't think there should be a comma after the column name - try just
> simply:
> 
> create index rgeo_gidx on swoodbridge.rgeo using gist (the_geom
> gist_geometry_ops);
> 
> 
> Kind regards,
> 
> Mark.
> 
> ------------------------
> WebBased Ltd
> 17 Research Way
> Tamar Science Park
> Plymouth
> PL6 8BT 
> 
> T: +44 (0)1752 797131
> F: +44 (0)1752 791023
> W: http://www.webbased.co.uk
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>