[postgis-users] ST_IsValid behaviour

2018-02-14 Thread Paolo Cavallini
Hi all, we noticed two strange things in the behaviour of ST_IsValid: * repeated vertices are not considered invalid * in case of multiple intersections on a same polygon, only the first one is reported. Is there an explanation for this? Thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & Pos

Re: [postgis-users] ST_IsValid behaviour

2018-02-14 Thread Paolo Cavallini
he ticket linked below summarizes the "invalid" argument, and > includes a link to the "valid" argument: > https://trac.osgeo.org/postgis/ticket/3425 > > Dan > > > On Wed, Feb 14, 2018 at 2:17 PM, Paolo Cavallini <mailto:cavall...@faunalia.it>> wrote:

[postgis-users] Updating geometry_column

2018-09-14 Thread Paolo Cavallini
Hi all, why some functions (e.g. st_minline) create geometries without the appropriate definitions, so that the geometry_column view iss not updated correctly (missing geometrytype and srid)? Thanks. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag

Re: [postgis-users] Updating geometry_column

2018-09-15 Thread Paolo Cavallini
larifying, this was my missing piece. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] Request for ideas to enhance the geometry viewer - GSoC

2019-01-29 Thread Paolo Cavallini
Are you sure you want to reimplement what a GIS does already? Doing proper, powerful styling it's a really big task. Sorry to jump in like this, I'm a strong advocate of open source tools also because you can reuse what is available, avoiding duplication of efforts. Cheers. Il 30 gennaio 2019 02

[postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
a lot. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
done already, but it complains that the versions don't match thanks On 03/04/19 18:10, Paul Ramsey wrote: > Put a symlink to the postgis-2.3.so file, named as postgis-2.1.so > > P > >> On Apr 3, 2019, at 9:08 AM, Paolo Cavallini wrote: >> >> Hi all, >&g

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
I mean: server versions don't match (9.4 vs 9.6) On 03/04/19 18:20, Paolo Cavallini wrote: > done already, but it complains that the versions don't match > thanks > > On 03/04/19 18:10, Paul Ramsey wrote: >> Put a symlink to the postgis-2.3.so file, named as postgis-

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
r 3, 2019, at 9:21 AM, Paolo Cavallini wrote: >> >> I mean: server versions don't match (9.4 vs 9.6) >> >> On 03/04/19 18:20, Paolo Cavallini wrote: >>> done already, but it complains that the versions don't match >>> thanks >>> >&g

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
; where probin like '%postgis%', can you check that ? > > In theory, any such function would be replaced by running > a soft upgrade of PostGIS in that database. unfortunately alter extension does not upgrade, and the error in upgradecluster is still the same. starting to feel los

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
27;, can you check that ? yes, I confirm > In theory, any such function would be replaced by running > a soft upgrade of PostGIS in that database. how do I do a soft upgrade, given that alter extension says the function is already installed in the database? Thanks a lot. -- Paolo Cavall

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
1.4 version is already installed and ALTER EXTENSION postgis UPDATE TO "2.3.1" with ERRORE: l'estensione "postgis" non ha un percorso di aggiornamento dalla versione "2.1.4" alla versione "2.3.1" unfortunately the VPN just went down, and I don't

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
ension/ alter extension postgis update to '2.3.1'; ERRORE: errore di sintassi a o presso "PARALLEL" -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
ion(); ERRORE: caricamento della libreria "/usr/lib/postgresql/9.4/lib/postgis-2.1.so" fallito: liblwgeom-2.1.4.so: impossibile aprire il file oggetto condiviso: File o directory non esistente thanks -- Paolo Cavallini - www.faunalia.eu QGIS.ORG

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
e 2.1.4 was released _after_ 2.3.1 (check the NEWS file). > In this case you could try a more recent 2.3.x version of PostGIS. 2.1.4 reached EOL long ago, I don't think this is the case. thanks. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/q

Re: [postgis-users] pg_dump on upgraded server

2019-04-03 Thread Paolo Cavallini
Hi all On 03/04/19 20:15, Paolo Cavallini wrote: > Hi again > > On 03/04/19 19:44, Sandro Santilli wrote: > >> This is unexpected, if 2.3.1 was _really_ installed. >> Can it be you manually installed 2.1.4 again on top >> of 2.3.1 ? What version you update to

Re: [postgis-users] Is there a MapInfo to PostGIS/PostgreSQL loader?

2019-08-27 Thread Paolo Cavallini
Not that I know of, but you can use ogr or QGIS for this. Cheers. On 27 August 2019 15:14:06 EEST, Shaozhong SHI wrote: >Hi, >Is there a MapInfo to PostGIS/PostgreSQL loader? For instance, use >psql.exe or something like that? > >Regards, > >Shao -- Sorry for being short___

[postgis-users] Broken link

2020-03-27 Thread Paolo Cavallini
Hi all, sorry for the noise, probably not the best cahnnel to report this, but in https://postgis.net/support/ there is a broken link: http://refcardz.dzone.com/refcardz/essential-postgis Cheers. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis

Re: [postgis-users] Broken link

2020-03-27 Thread Paolo Cavallini
Il 27/03/20 14:41, Sandro Santilli ha scritto: > On Fri, Mar 27, 2020 at 11:22:17AM +0100, Paolo Cavallini wrote: >> Hi all, >> sorry for the noise, probably not the best cahnnel to report this, but >> in https://postgis.net/support/ there is a broken link: >> http://

Re: [postgis-users] Excel connecting and inputting into PostGIS

2020-08-15 Thread Paolo Cavallini
The easiest I know of is through QGIS. Cheers. On 15 August 2020 17:07:06 CEST, Imre Samu wrote: >> Is there a simple way for users to load their data into PostGIS? > >CSV? >- save as a CSV file ( contains LAT , LON columns ) > - import CSV to Postgres >- convert LAT/LON to geometry columns .

[postgis-users] postgis_restore

2020-10-09 Thread Paolo Cavallini
Hi all, is the utility supposed to work restoring a 9.3/2.1 dump into a 12.0/3.0 db? I keep on getting pg_restore: error: one of -d/--dbname and -f/--file must be specified Cheers. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more

Re: [postgis-users] postgis_restore

2020-10-09 Thread Paolo Cavallini
Thanks! Il 09/10/20 13:46, Matti Linnanvuori ha scritto: > Hi! > > That has been fixed in 3.0.1. > https://trac.osgeo.org/postgis/ticket/4605 > > Best regards, Matti Linnanvuori > > >> On 9 Oct 2020, at 13.41, Paolo Cavallini > <mailto:cavall...@faunalia

[postgis-users] Moving PostGIS to a different schema

2020-10-09 Thread Paolo Cavallini
Hi all, alter extension postgis set schema public ; returns, in PostGIS 3.0 ERROR: extension "postgis" does not support SET SCHEMA any solution to this? Thanks. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGI

Re: [postgis-users] Moving PostGIS to a different schema

2020-10-09 Thread Paolo Cavallini
Thanks Regina! Il 09/10/20 15:26, Regina Obe ha scritto: >> alter extension postgis set schema public ; returns, in PostGIS 3.0 >> ERROR: extension "postgis" does not support SET SCHEMA >> >> any solution to this? >> Thanks. >> -- >> Paolo

[postgis-users] shp import through GDAL fails

2020-10-13 Thread Paolo Cavallini
. -- 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 Paolo Cavallini
ype 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 ha

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

2020-10-13 Thread Paolo Cavallini
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 Paolo Cavallini
gt; >> 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... >> >> -- >> Pao

[postgis-users] spatial_ref_sys not populated after upgrade

2021-07-23 Thread Paolo Cavallini
Hi all, after an upgrade of Potsgres and Postgis the spatial_ref_sys table is created, but not populated. I kind of remember having the same issue, but I cannot find traces in my notes nor on the internet. Any hint of what can have be gone wrong? Cleanest way to fix this? TIA Cheers. -- Paolo

[postgis-users] ST_Split returning multipart

2023-08-09 Thread Paolo Cavallini
each subnet as a single object. Am I missing something? Thanks for any hint. -- Paolo Cavallini www.faunalia.eu Training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org

[postgis-users] Adding raster overviews

2012-12-04 Thread Paolo Cavallini
t; linea 24 a RETURN funzione PL/pgSQL "addoverviewconstraints" linea 61 a assegnazione psql:dtm_tiled.sql:1468: ERROR: Unable to add the overview constraint. Is the schema name, table name or column name incorrect? ... Anything wrong? PostGIS 2.0.2, GDAL 1.9.0 Thanks. -- Paolo Cavall

Re: [postgis-users] Adding raster overviews

2012-12-04 Thread Paolo Cavallini
Il 04/12/2012 20:53, Paolo Cavallini ha scritto: > Hi all. > I just came across to an old issue: > http://trac.osgeo.org/postgis/ticket/1646 I should really stop working earlier: missing permissions on raster_columns Sorry for the noise. -- Paolo Cavallini - Faunalia www.faunalia.eu Ful

[postgis-users] Incorrect geometry_columns?

2012-12-09 Thread Paolo Cavallini
merge_strade LIMIT 1; st_srid 3003 SELECT ST_geometrytype(geom) FROM merge_strade LIMIT 1; st_geometrytype ST_LineString Am I missing something? Thanks. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.

Re: [postgis-users] Incorrect geometry_columns?

2012-12-09 Thread Paolo Cavallini
Il 09/12/2012 14:52, Francois Hugues ha scritto: > Hi, > > Are you sure you don't have mixed srid ? Sure: > Select st_srid(geom) from merge_strade group by st_srid(geom); st_srid 3003 Thanks. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.

Re: [postgis-users] Incorrect geometry_columns?

2012-12-10 Thread Paolo Cavallini
ion, st_convexhull, etc.). Is this a known issue? All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users mailing list postgis-us

Re: [postgis-users] Incorrect geometry_columns?

2012-12-10 Thread Paolo Cavallini
..", you would have to > alter > the table to use the typemod: I see, thanks a lot. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ p

Re: [postgis-users] Incorrect geometry_columns?

2012-12-10 Thread Paolo Cavallini
Il 10/12/2012 15:22, Sandro Santilli ha scritto: > Or to cast on select (very useful with views..) > > create table test as select code_dept, > st_centroid(geom)::geometry(point, 2154) as geom from dept; quite nice, thanks. -- Paolo Cavallini - Faunalia www.faunalia.eu Full con

Re: [postgis-users] Is it worth to load background raster into postgis?

2013-02-06 Thread Paolo Cavallini
cating them. > Right now most of our raster are in ecw format and I'm searching a way to > distribute them over LAN.. > May be a mosaic/vrt.. > Ay suggestion? WMS All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi cor

Re: [postgis-users] Is it worth to load background raster into postgis?

2013-02-08 Thread Paolo Cavallini
I do not know what is too much for you, certainly it will increase a lot. All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___

Re: [postgis-users] Is it worth to load background raster into postgis?

2013-02-08 Thread Paolo Cavallini
Il 08/02/2013 20:27, Pietro Rossin ha scritto: > We don't have a WMS server yet, any suggestion for a "not too difficult to > configure" > solution? OT here, but cetainly the easiest is aptitude install qgis-mapserver All the best. -- Paolo Cavallini - Faunalia www.

Re: [postgis-users] liblwgeom and LGPL?

2013-03-28 Thread Paolo Cavallini
we do il GPL for a reason. All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mo

Re: [postgis-users] error on copying geometries between geometry columns

2013-08-12 Thread Paolo Cavallini
gt; Why? Try SET geom_simply=ST_Multi(ST_SimplifyPreserveTopology(st_multi(geom), 100)) - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1

[postgis-users] make error

2013-08-27 Thread Paolo Cavallini
#x27; make: *** [all] Error 1 Debian testing, up to date; previous compilation of earlier PG versions went fine on this machine. Any hint? All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/

Re: [postgis-users] make error

2013-08-27 Thread Paolo Cavallini
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 27/08/2013 16:38, Paolo Cavallini ha scritto: > gcc: error: unrecognized command line option > ‘-fno-aggressive-loop-optimizations’ In fact, this is a new gcc option: http://gcc.gnu.org/gcc-4.8/changes.html Has anyone compiled successfull

Re: [postgis-users] postgis raster : viewer with qgis 2.0?

2013-09-18 Thread Paolo Cavallini
with several tiles at the same position, e.g. a raster time series) are handled, my guess is that all tiles are loaded on top of each other. this shouldn't be. We would love to improve DB Manager, in this and other respects; if you are interested please let us knoe. All the best

Re: [postgis-users] postgis raster : viewer with qgis 2.0?

2013-09-18 Thread Paolo Cavallini
since DB Manager is a plugin) yes, right - DB Manager is now default component of QGIS. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users

Re: [postgis-users] Wiki editing

2013-10-30 Thread Paolo Cavallini
ttp://trac.osgeo.org/postgis/wiki/UsersWikiQGIS > > Thank you, very useful. ?? PostGIS srid are not supported, so you have to manually choose the right projection and coordinate system when adding a PostGIS geometry layer. all the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full cont

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-20 Thread Paolo Cavallini
: * PostGIS is GPL, it is nice and natural not to mix up licences * I do not like the idea of somebody taking up the results of my investment, and use it for some closed source stuff. Thanks. - -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html

Re: [postgis-users] The first release of the PostGIS Add-ons is out!

2013-11-20 Thread Paolo Cavallini
ce'. > > Unfortunately GPL imposes both. from my point of view, this is a Very Good Thing - -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG

[postgis-users] shp2pgsql failing on large shp

2013-11-21 Thread Paolo Cavallini
way to solve this. All the best. - -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlKN9ZMACgkQ

Re: [postgis-users] shp2pgsql failing on large shp

2013-11-21 Thread Paolo Cavallini
Thanks. - -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlKOUNAACgkQ/NedwLUzIr4BZwCgmfWqUxMeY097dkk62f

Re: [postgis-users] Overlapping of polygons with SimplifyPreserveTopology

2013-12-09 Thread Paolo Cavallini
ck ? Hi Luca, you really need to use full topology for this. ST_SimplifyPreserveTopology simply prevents topological errors, it does not guarantee sharing of nodes etc. Good luck. - -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html -BEGIN

Re: [postgis-users] Versioning system to use with QGIS + Postgis

2014-06-06 Thread Paolo Cavallini
have a look at Vincent Mora’s recent work at Oslandia : > https://github.com/Oslandia/qgis-versioning Unifying the efforts, rather than duplicating, seems a sensible way. All the best, and thanks. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia

Re: [postgis-users] raster2pgsql gui

2014-06-09 Thread Paolo Cavallini
Il 08/06/2014 10:21, Pieter du Plooy ha scritto: > Has anyone ever attempted to create a raster2pgsql gui (like the shp2pgsql > gui). > > As I am sometimes lazy to use command line, this could be a very nice to have Have you checked DB Manager, in QGIS? All the best. -- Pao

Re: [postgis-users] Export from postGIS to ESRI Personal GeoDatabase

2014-12-03 Thread Paolo Cavallini
ere (open > source of course) Hi Rémi, do you have a link to it? Merci. - -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1 iEYEARECAAYFAlR/Q+UACgkQ/NedwLUzIr4byACfdjulKaH5

Re: [postgis-users] Checking Road Network Topology

2015-01-21 Thread Paolo Cavallini
Il 22/01/2015 01:28, Mark Wynter ha scritto: > I’m open to any ideas, leads or offers of help. I might be able to help, especially on the QGIS side; perhaps setting up Processing modules could make the workflow easier. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS

[postgis-users] External rasters: access disabled?

2015-02-05 Thread Paolo Cavallini
RETURN Debian sid, pg 9.4, PostGIS 2.1.4+dfsg-2, GDAL 1.10.1+dfsg-8+b3 They worked before. As it stands, they are pretty useless. Anyone has a good explanation for this? All the best, and thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.

Re: [postgis-users] External rasters: access disabled?

2015-02-05 Thread Paolo Cavallini
Il 05/02/2015 10:24, Tom van Tilburg ha scritto: > Hi Paolo, > > I bumped into this as well, but it is by design and the solution is > fairly easy. > Read this: > http://postgis.net/docs/postgis_installation.html#install_short_version OK, clear, thanks. -- Paolo Cavallini

Re: [postgis-users] Getting TopologyExections when trying to node linestrings to create an overlay

2015-02-08 Thread Paolo Cavallini
ways seems to be some weird case that requires manually edits. Hi John, have you tried ST_MakeValid? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html *New course* "QGIS for naturalists":

Re: [postgis-users] Line of sight (LOS) Calculation

2015-03-09 Thread Paolo Cavallini
tly released, r.los has been replaced by the (much more efficient) r.viewshed. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@list

Re: [postgis-users] Visualizing PostGIS 3D geometries

2015-07-07 Thread Paolo Cavallini
ome visualization toolkit like VTK to visualize these geometries? QGIS 2.10 has some basic support for 3D, will have more in 2.12. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ post

[postgis-users] Errors restoring a db

2015-12-21 Thread Paolo Cavallini
store.sql:8262507: invalid command \N psql:geosisma_geo_restore.sql:8262508: invalid command \. psql:geosisma_geo_restore.sql:8262513: ERROR: syntax error at or near "1" LINE 1: 1 12.9.2010 010620E610010001030001000500... ^ Any explanation or possible solut

[postgis-users] Handling LINESTRINGM

2015-12-22 Thread Paolo Cavallini
Hi all, I discovered that LINESTRINGM are lost during a dump/restore (the table is created, but completely empty). Is this a known bug? So I tried converting them to LINESTRING, but could not find a reasonable way: anyone has a suggestion? Thanks. -- Paolo Cavallini - www.faunalia.eu QGIS

Re: [postgis-users] Errors restoring a db

2015-12-22 Thread Paolo Cavallini
s though. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] Errors restoring a db

2015-12-22 Thread Paolo Cavallini
Il 22/12/2015 14:33, Birgit Laggner ha scritto: > You don't have to use postgres user per se - but the user using the > 'copy' command has to be a superuser. Perhaps it might be easier to > change your own user role accordingly? OK, I see, thanks. All the b

Re: [postgis-users] Handling LINESTRINGM

2015-12-23 Thread Paolo Cavallini
Il 22/12/2015 16:25, Sandro Santilli ha scritto: > On Tue, Dec 22, 2015 at 01:27:36PM +0100, Paolo Cavallini wrote: >> Hi all, >> I discovered that LINESTRINGM are lost during a dump/restore (the table >> is created, but completely empty). Is this a known bug? > > Ne

Re: [postgis-users] Handling LINESTRINGM

2015-12-28 Thread Paolo Cavallini
rmed here with 2.2.0, the problem was found with 2.1.4 (standard in Debian jessie). thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org h

Re: [postgis-users] Postgis upgrade problem

2016-09-22 Thread Paolo Cavallini
that has 2.2 On Debian installing a new PostgreSQL version does not remove the previous one, but makes it listening on an higher port, so possibly you're using the wrong one. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html

[postgis-users] -R rasters fail to \i

2017-01-05 Thread Paolo Cavallini
xec_simple_query, postgres.c:994 Tempo: 0,138 ms ROLLBACK Tempo: 0,135 ms psql:dtm_ext.sql:8: ERRORE: 42P01: la relazione "dtm_ext" non esiste POSIZIONE: RangeVarGetRelidExtended, namespace.c:420 Tempo: 12,499 ms === Previously the same command was working fine. postgresql-9.6-po

Re: [postgis-users] -R rasters fail to \i

2017-01-05 Thread Paolo Cavallini
@Y@YA6;;%�AQ_�1G�ip thanks a lot -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all&geo=IT&q=qgis,arcgis ___ postgis-users mailing list postgis-

Re: [postgis-users] -R rasters fail to \i

2017-03-06 Thread Paolo Cavallini
Il 05/01/2017 11:58, Paolo Cavallini ha scritto: > Hi all, > creating an out-of-db raster fails: > === > raster2pgsql -s 3003 -I -M -C -R > /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf dtm_ext > dtm_ext.sql > > \i dtm_ext.sql > BEGIN > Tempo: 0,234 ms >