[postgis-users] operator does not exist

[Sandro Santilli]

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;