[postgis-users] shp import through GDAL fails

[b.j.kobben at utwente.nl]

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-bounces at lists.osgeo.org<mailto:postgis-users-bounces at lists.osgeo.org> on behalf of cavallini at faunalia.it<mailto:cavallini at 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 at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201013/9fb98bb7/attachment.html>