[postgis-users] shp import through GDAL fails

[Paolo Cavallini]

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