[GRASS-dev] [GRASS GIS] #2436: v.out.postgis: Unsupported geometry type / Unable to write feature in vector map

GRASS GIS GRASS GIS developer
,
1

#2436: v.out.postgis: Unsupported geometry type / Unable to write feature in
vector map
---------------------------+------------------------------------------------
Reporter: martin | Owner: grass-dev@…
     Type: defect | Status: new
Priority: normal | Milestone:
Component: Vector | Version: svn-trunk
Keywords: v.out.postgis | Platform: Linux
      Cpu: x86-64 |
---------------------------+------------------------------------------------
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.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2436&gt;
GRASS GIS <http://grass.osgeo.org>

2

#2436: v.out.postgis: Unsupported geometry type / Unable to write feature in
vector map
---------------------------+------------------------------------------------
Reporter: martin | Owner: grass-dev@…
     Type: defect | Status: new
Priority: normal | Milestone:
Component: Vector | Version: svn-trunk
Keywords: v.out.postgis | Platform: Linux
      Cpu: x86-64 |
---------------------------+------------------------------------------------

Comment(by martin):

Mapset <nlcd2011error> in Location <wgs84>[[BR]]
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[[BR]]
[...][[BR]]
Reading symbols from
/opt/GRASS7/grass-7.1.svn/bin/v.out.postgis...done.[[BR]]
(gdb) r[[BR]]
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[[BR]]
warning: no loadable sections found in added symbol-file system-supplied
DSO at 0x7ffff7ffa000[[BR]]
[Thread debugging using libthread_db enabled][[BR]]
Using host libthread_db library "/lib/x86_64-linux-
gnu/libthread_db.so.1".[[BR]]
No database connection for layer <1>[[BR]]
Using PostGIS format[[BR]]
WARNUNG: Unsupported geometry type (64)[[BR]]
WARNUNG: Unable to write feature in vector map
<newcs_correct_pg_collect>[[BR]]
FEHLER: Feature type 64 is not supported[[BR]]
NOTICE: table "newcs_correct_pg_collect" does not exist, skipping[[BR]]
KONTEXT: SQL statement "DROP TABLE IF EXISTS
public.newcs_correct_pg_collect RESTRICT"[[BR]]
PL/pgSQL function dropgeometrytable(character varying,character
varying,character varying) line 15 at EXECUTE statement[[BR]]
[Inferior 1 (process 7881) exited with code 01][[BR]]

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2436#comment:1&gt;
GRASS GIS <http://grass.osgeo.org>

3

#2436: v.out.postgis: Unsupported geometry type / Unable to write feature in
vector map
---------------------------+------------------------------------------------
Reporter: martin | Owner: martinl
     Type: defect | Status: assigned
Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-trunk
Keywords: v.out.postgis | Platform: Linux
      Cpu: x86-64 |
---------------------------+------------------------------------------------
Changes (by martinl):

* cc: grass-dev@… (added)
  * owner: grass-dev@… => martinl
  * status: new => assigned
  * milestone: => 7.0.0

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2436#comment:2&gt;
GRASS GIS <http://grass.osgeo.org>

4

#2436: v.out.postgis: Unsupported geometry type / Unable to write feature in
vector map
---------------------------+------------------------------------------------
Reporter: martin | Owner: martinl
     Type: defect | Status: assigned
Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-trunk
Keywords: v.out.postgis | Platform: Linux
      Cpu: x86-64 |
---------------------------+------------------------------------------------

Comment(by martinl):

Please could you try r62360 (trunk)?

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2436#comment:3&gt;
GRASS GIS <http://grass.osgeo.org>

5

#2436: v.out.postgis: Unsupported geometry type / Unable to write feature in
vector map
---------------------+------------------------------------------------------
  Reporter: martin | Owner: martinl
      Type: defect | Status: closed
  Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-trunk
Resolution: fixed | Keywords: v.out.postgis
  Platform: Linux | Cpu: x86-64
---------------------+------------------------------------------------------
Changes (by martin):

  * status: assigned => closed
  * resolution: => fixed

Comment:

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

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2436#comment:4&gt;
GRASS GIS <http://grass.osgeo.org>