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 best. -- Paolo Cavallini - www.faunalia.e

Re: [postgis-users] Handling LINESTRINGM

2015-12-22 Thread Sandro Santilli
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? Never heard before. Can you reproduce with a small (single linestring with 2 vertexes) dump

Re: [postgis-users] Errors restoring a db

2015-12-22 Thread Birgit Laggner
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? Am 22.12.2015 um 14:25 schrieb Paolo Cavallini: Il 22/12/2015 14:21, Humberto Cereser Ibanez ha scritto: Hi Paolo, If

Re: [postgis-users] Handling LINESTRINGM

2015-12-22 Thread Birgit Laggner
Hi Paolo, perhaps converting into ewkt or ewkb format with st_asewkt() or st_asewkb() could be a workaround? I haven't worked with geometries including m-coordinates yet, so this is only an idea... Good luck and regards, Birgit Am 22.12.2015 um 13:27 schrieb Paolo Cavallini: Hi all, I disc

Re: [postgis-users] Errors restoring a db

2015-12-22 Thread Paolo Cavallini
Il 22/12/2015 14:21, Humberto Cereser Ibanez ha scritto: > Hi Paolo, > > If your sql is trying to use 'copy' command, I experencied that the > superuser postgres can run it and stop the errors that you showed. I see, thanks. Not very nice to be forced using postgres though. All the best. -- Paol

Re: [postgis-users] Errors restoring a db

2015-12-22 Thread Humberto Cereser Ibanez
Hi Paolo, If your sql is trying to use 'copy' command, I experencied that the superuser postgres can run it and stop the errors that you showed. Humberto Ibanez 2015-12-22 4:39 GMT-02:00 Paolo Cavallini : > Hi all, > I'm getting errors while restoring a db from a 1.5 dump to a > POSTGIS="2.1.4

[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 & PostGI