[postgis-users] operator does not exist

[Denis Rouzaud]

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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users