On Wed, Jan 22, 2014 at 11:52:30AM +0100, Denis Rouzaud wrote: > Hi, > > When using pg_restore, I get this error: > > pg_restore: [archiver (db)] could not execute query: ERROR: operator > does not exist: public.geometry && public.geometry > LINE 1: SELECT $1 && $2 AND _ST_Overlaps($1,$2) > > I don't understand since \do && returns: > public | && | geometry | geometry | boolean | > > I just did install pg 9.3 + postgis 2.1 on a server and trying to > use dumps from pg 9.1 + postgis 2.0.
You shouldn't use "pg_restore" but "postgis_restore.pl". See "Hard upgrade" section in the manual. --strk; _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
