Hi Darafei Il 13/10/20 15:55, Darafei "Komяpa" Praliaskouski ha scritto:
> - is postgis installed into the same database where you are unpacking > dump to? common issue is installing to "postgres" database and then > expecting to have it in "gis" or "$yourapp" one. sure > - can you share a full reproducer scenario? there are two in the ticket > where there is no issue. can you retell step-by-step what you are doing > to get an error? I get the error when I import from QGIS (which uses GDAL behind the scenes): ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist RIGA 1: SELECT AddGeometryColumn('public','world_simpl','geom',3857,... ^ NOTA: No function matches the given name and argument types. You might need to add explicit type casts. This on: PostgreSQL 13.0 (Debian 13.0-3) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.0-13) 10.2.0, 64-bit Whereas exactly the same thing on: PostgreSQL 11.9 (Debian 11.9-0+deb10u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit works smoothly, as has always done. Cheers. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users