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

[Jan Hartmann]

Hi Steve, just leave out the comma before gist_geometry_ops

Jan

Stephen Woodbridge wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>