I think the function AddGeometryColumn is deprecated already for some time (now should be ST_AddGeometryColumn) so maybe in postgis v13 it does not work anymore...
yours -- Barend Köbben Senior Lecturer – ITC-GIP & ATLAS, University Twente PO Box 217, 7500 AE Enschede (The Netherlands) +31-(0)53 4874 253 Mon-, Tues-, Thursday afternoons: ITC Building 1-065 Wednesdays: Citadel building H-100 On 13/10/2020, 16:16, "postgis-users on behalf of Paolo Cavallini" <postgis-users-boun...@lists.osgeo.org<mailto:postgis-users-boun...@lists.osgeo.org> on behalf of cavall...@faunalia.it<mailto:cavall...@faunalia.it>> wrote: 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<mailto:postgis-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
