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

[Mark Cave-Ayland]

> -----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