Re: [postgis-users] shp import through GDAL fails

2020-10-13 Thread Paolo Cavallini 
Indeed, on a fresh db on one of our servers the import works.
I'll check further in the others.
Sorry for the noise.
Cheers.

Il 13/10/20 17:22, Regina Obe ha scritto:
>> this was my initial guess, that's why I'm asking here (Postgis 3, that is).
>> Thanks.
>>
>> Il 13/10/20 16:21, b.j.kob...@utwente.nl ha scritto:
>>> I think the function AddGeometryColumnis deprecated already for some
>>> time (now should be ST_AddGeometryColumn)so maybe in postgis v13 it
>>> does not work anymore...
>>
>> --
>> 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
> 
> The function is AddGeometryColumn.  AddGeometryColumn still exists.  
> http://postgis.net/docs/manual-3.0/AddGeometryColumn.html 
> 
> We have never had nor will we ever have a ST_AddGeometryColumn
> 
> So to Darafei's point, make sure you are connected to a database with PostGIS 
> installed and also make sure the schema PostGIS is installed in is in the 
> database search path.
> Also make sure the account you are using in QGIS is does not have search_path 
> overridden.
> 
> Thanks,
> Regina
> 
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> 

-- 
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

Re: [postgis-users] shp import through GDAL fails

2020-10-13 Thread Regina Obe 
> this was my initial guess, that's why I'm asking here (Postgis 3, that is).
> Thanks.
> 
> Il 13/10/20 16:21, b.j.kob...@utwente.nl ha scritto:
> > I think the function AddGeometryColumnis deprecated already for some
> > time (now should be ST_AddGeometryColumn)so maybe in postgis v13 it
> > does not work anymore...
> 
> --
> 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

The function is AddGeometryColumn.  AddGeometryColumn still exists.  
http://postgis.net/docs/manual-3.0/AddGeometryColumn.html 

We have never had nor will we ever have a ST_AddGeometryColumn

So to Darafei's point, make sure you are connected to a database with PostGIS 
installed and also make sure the schema PostGIS is installed in is in the 
database search path.
Also make sure the account you are using in QGIS is does not have search_path 
overridden.

Thanks,
Regina

___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] shp import through GDAL fails

2020-10-13 Thread Paolo Cavallini 
this was my initial guess, that's why I'm asking here (Postgis 3, that is).
Thanks.

Il 13/10/20 16:21, b.j.kob...@utwente.nl ha scritto:
> I think the function AddGeometryColumnis deprecated already for some
> time (now should be ST_AddGeometryColumn)so maybe in postgis v13 it does
> not work anymore...

-- 
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

Re: [postgis-users] shp import through GDAL fails

2020-10-13 Thread b.j.kob...@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" 
mailto:postgis-users-boun...@lists.osgeo.org>
 on behalf of 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
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

Re: [postgis-users] shp import through GDAL fails

2020-10-13 Thread 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
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] shp import through GDAL fails

2020-10-13 Thread Jeff McKenna 

On 2020-10-13 10:48 a.m., Paolo Cavallini wrote:

Hi all,
we are consistently getting errors during shapefiles import:
https://github.com/OSGeo/gdal/issues/3053
Initially we believed this was due to unsupported syntax by GDAL, but
from the ticket the issue seems more related to PostGIS, possibly packaging.
Any hint will be welcome.
Cheers.



Hi Paolo,

I swear by ogr2ogr for all PostGIS data management on all servers, I 
haven't hit this error before though; could you attach a shp subset of 
your data, to test this locally?


-jeff



--
Jeff McKenna
MapServer Consulting and Training Services
co-founder of FOSS4G
http://gatewaygeo.com/
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] shp import through GDAL fails

2020-10-13 Thread Komяpa 
Hello,

Let's start with first things:
 - 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.
 - 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?

On Tue, Oct 13, 2020 at 4:45 PM Paolo Cavallini 
wrote:

> Hi all,
> we are consistently getting errors during shapefiles import:
> https://github.com/OSGeo/gdal/issues/3053
> Initially we believed this was due to unsupported syntax by GDAL, but
> from the ticket the issue seems more related to PostGIS, possibly
> packaging.
> Any hint will be welcome.
> 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
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] shp import through GDAL fails

2020-10-13 Thread Paolo Cavallini 
Hi all,
we are consistently getting errors during shapefiles import:
https://github.com/OSGeo/gdal/issues/3053
Initially we believed this was due to unsupported syntax by GDAL, but
from the ticket the issue seems more related to PostGIS, possibly packaging.
Any hint will be welcome.
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