[postgis-users] no default operator class for access method "gist"

[Thomas Haechler]

Vinko Vrsalovic wrote:
> 
> Or you're running an old version of Postgres,

nope, 2.7.1

> or you forgot
>   $ createlang plpgsql [newdb]
>   $ psql -f /path/to/postgis.sql [newdb]
> 
> > $ psql -d [newdb] -f [outfile]

hmmmm, you are right! I guess I can ignore all the error messages I get
now  ;-)   :

psql:webgis_o_ind.out:24: ERROR:  function plpgsql_call_handler already
exists with same argument types
psql:webgis_o_ind.out:32: ERROR:  Language plpgsql already exists
psql:webgis_o_ind.out:40: ERROR:  function postgis_version already
exists with same argument types
psql:webgis_o_ind.out:55: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index 'spatial_ref_sys_pkey' for table 'spatial_ref_sys'
psql:webgis_o_ind.out:55: ERROR:  Relation 'spatial_ref_sys' already
exists

<---snip--->

psql:webgis_o_ind.out:1093: ERROR:  OperatorDef: operator ">>" already
defined
psql:webgis_o_ind.out:1106: ERROR:  OperatorDef: operator "<<" already
defined
psql:webgis_o_ind.out:1119: ERROR:  OperatorDef: operator "&>" already
defined
psql:webgis_o_ind.out:1132: ERROR:  OperatorDef: operator "&<" already
defined
psql:webgis_o_ind.out:1145: ERROR:  OperatorDef: operator "&&" already
defined
psql:webgis_o_ind.out:1158: ERROR:  OperatorDef: operator "=" already
defined
psql:webgis_o_ind.out:1171: ERROR:  OperatorDef: operator "~=" already
defined
psql:webgis_o_ind.out:1184: ERROR:  OperatorDef: operator "@" already
defined
psql:webgis_o_ind.out:1197: ERROR:  OperatorDef: operator "~" already
defined
psql:webgis_o_ind.out:1210: ERROR:  OperatorDef: operator "<" already
defined
psql:webgis_o_ind.out:1223: ERROR:  OperatorDef: operator ">" already
defined 
 
however, the indexes are there and the layer shows up.
thanks,

Thomy


-- 

THOMAS HAECHLER

Geographic Information Systems Division
Institute of Geography
University of Zurich
Switzerland

thomas.haechler at geo.unizh.ch