Hi Cedric, 2016-11-21 9:26 GMT+01:00 Cedric Duprez <[email protected]>:
> Hi Giuseppe, > > Thanks for your answer and your help. > Here is the output of \do @: > The operator signs related to PostGIS datatypes are the following ones: > Schéma | Nom | Type de l'arg. gauche | Type de l'arg. droit | Type > du résultat | Description > ------------+-----+-----------------------+----------------- > -----+------------------+---------------------------- > public | @ | geometry | geometry | > boolean | > public | @ | geometry | raster | > boolean | > public | @ | raster | geometry | > boolean | > public | @ | raster | raster | > boolean | > > The @ operator for raster type is in the public schema. > Weird, isn't it? This is due to how the dump has been restored in the target instance (PostgreSQL 9.5 + PostGIS 2.3). Functions and operators have been imported in the public schema in the session opened by pg_restore. PostGIS 2.1 does not fully-qualify functions and operators, so are not recreated in the original schemas when they are restored from a logical backup. Which user is used to connect to the database when pg_restore is executed? Regards, Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL & PostGIS Training, Services and Support [email protected] | www.2ndQuadrant.it
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
