<div dir="ltr">Hi Cedric,<br><div><div class="gmail_extra"><br><div class="gmail_quote">2016-11-21 9:26 GMT+01:00 Cedric Duprez <span dir="ltr"><<a href="mailto:Cedric.Duprez@ign.fr" target="_blank">Cedric.Duprez@ign.fr</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Giuseppe,<br>
<br>
Thanks for your answer and your help.<br>
Here is the output of \do @:<br></blockquote><div><br></div><div>The operator signs related to PostGIS datatypes are the following ones:<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
    Schéma   | Nom | Type de l'arg. gauche | Type de l'arg. droit | Type<br>
du résultat |        Description<br>
------------+-----+-----------<wbr>------------+-----------------<wbr>-----+------------------+-----<wbr>-----------------------<br>
  public     | @   | geometry              | geometry             |<br>
boolean          |<br>
  public     | @   | geometry              | raster               |<br>
boolean          |<br>
  public     | @   | raster                | geometry             |<br>
boolean          |<br>
  public     | @   | raster                | raster               |<br>
boolean          |<br>
<br>
The @ operator for raster type is in the public schema.<br>
Weird, isn't it?</blockquote></div><br></div><div class="gmail_extra">This is due to how the dump has been restored in the target instance (PostgreSQL 9.5 + PostGIS 2.3).<br></div><div class="gmail_extra">Functions and operators have been imported in the public schema in the session opened by pg_restore.<br><br></div><div class="gmail_extra">PostGIS 2.1 does not fully-qualify functions and operators, so are not recreated in the original schemas<br></div><div class="gmail_extra">when they are restored from a logical backup.<br><br></div><div class="gmail_extra">Which user is used to connect to the database when pg_restore is executed?<br><br></div><div class="gmail_extra">Regards,<br></div><div class="gmail_extra">Giuseppe.<br clear="all"></div><div class="gmail_extra"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><span></span>Giuseppe Broccolo - 2ndQuadrant Italy
<br>PostgreSQL & PostGIS Training, Services and Support
<br><a href="mailto:giuseppe.broccolo@2ndQuadrant.it" target="_blank">giuseppe.broccolo@2ndQuadrant.it</a> | <a href="http://www.2ndQuadrant.it" target="_blank">www.2ndQuadrant.it</a>
</div></div></div></div>
</div></div></div>