Opened 5 years ago

Closed 5 years ago

#2436 closed defect (fixed)

v.out.postgis: Unsupported geometry type / Unable to write feature in vector map

Reported by: martin Owned by: martinl
Priority: normal Milestone: 7.0.0
Component: Vector Version: svn-trunk
Keywords: v.out.postgis Cc: grass-dev@…
CPU: x86-64 Platform: Linux

Description

This package:

http://foxtrot.mgras.net/static/newcs_correct_collect.tbz

contains a packed vector map plus a little text file. The top of the text file shows two commands to export the vector map into PostGIS (PostGIS geometry, no topology). The "v.out.ogr" works as promised but the "v.out.postgis" doesn't .... and the bottom part of the text file contains the corresponding debug output.

Change History (4)

comment:1 Changed 5 years ago by martin

Mapset <nlcd2011error> in Location <wgs84>
GRASS 7.1.svn > gdb --args v.out.postgis input=newcs_correct_collect type=area olayer=newcs_correct_pg_collect dsn="PG:host=localhost dbname=landcover user=martin" options="FID=ogc_fid, GEOMETRY_NAME=wkb_geometry, SPATIAL_INDEX=YES, PRIMARY_KEY=YES, SRID=4326" --verbose
[...]
Reading symbols from /opt/GRASS7/grass-7.1.svn/bin/v.out.postgis...done.
(gdb) r
Starting program: /opt/GRASS7/grass-7.1.svn/bin/v.out.postgis input=newcs_correct_collect type=area olayer=newcs_correct_pg_collect dsn=PG:host=localhost\ dbname=landcover\ user=martin options=FID=ogc_fid,\ GEOMETRY_NAME=wkb_geometry,\ SPATIAL_INDEX=YES,\ PRIMARY_KEY=YES,\ SRID=4326 --verbose
warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7ffff7ffa000
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
No database connection for layer <1>
Using PostGIS format
WARNUNG: Unsupported geometry type (64)
WARNUNG: Unable to write feature in vector map <newcs_correct_pg_collect>
FEHLER: Feature type 64 is not supported
NOTICE: table "newcs_correct_pg_collect" does not exist, skipping
KONTEXT: SQL statement "DROP TABLE IF EXISTS public.newcs_correct_pg_collect RESTRICT"
PL/pgSQL function dropgeometrytable(character varying,character varying,character varying) line 15 at EXECUTE statement
[Inferior 1 (process 7881) exited with code 01]

comment:2 Changed 5 years ago by martinl

Cc: grass-dev@… added
Milestone: 7.0.0
Owner: changed from grass-dev@… to martinl
Status: newassigned

comment:3 Changed 5 years ago by martinl

Please could you try r62360 (trunk)?

comment:4 Changed 5 years ago by martin

Resolution: fixed
Status: assignedclosed

Did that - and it works as expected/promised/before. Great !

Note: See TracTickets for help on using tickets.