Hi Sandro,
Thanks a lot for your reply.
It did works perfectly well.
Cheers,
Denis
On 22. 01. 14 12:11, Sandro Santilli wrote:
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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
