[postgis-users] no default operator class for access method "gist"
Thomas Haechler
thaechl at geo.unizh.ch
Thu Aug 15 03:32:53 PDT 2002
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
More information about the postgis-users
mailing list