[GRASS-dev] [GRASS GIS] #795: v.out.ogr and centroids in GRASS 6.2.1 and PostGIS

#795: v.out.ogr and centroids in GRASS 6.2.1 and PostGIS
-----------------------------------------------------+----------------------
Reporter: hancar | Owner: grass-dev@lists.osgeo.org
     Type: defect | Status: new
Priority: normal | Milestone:
Component: default | Version: unspecified
Keywords: v.out.ogr centroid grass postgis gentoo | Platform: Linux
      Cpu: x86-32 |
-----------------------------------------------------+----------------------
= v.out.ogr and centroids in GRASS 6.2.1 and PostGIS =
As a gentoo user I used GRASS 6.2.1 and PostGIS 1.3.1

The problem is, this command:
{{{
v.out.ogr input=soils type=point,line,centroid dsn='PG:host=localhost
dbname=spearpg user=postgres' olayer=soils format=PostgreSQL
lco='OVERWRITE=YES'
}}}

produces many of these print-outs:

{{{
Command: INSERT INTO "soils" (wkb_geometry , "cat", "label") VALUES
(GeomFromEWKT('SRID=2;LINESTRING (599923.53439599997364
4925869.863033999688923)'::TEXT) , 11, 'CaE')
ERROR 1: INSERT command for new feature failed.
ERROR: geometry requires more points
}}}

whereas this:
{{{
  v.out.ogr input=soils type=point,line,boundary dsn='PG:host=localhost
dbname=spearpg user=postgres' olayer=soils format=PostgreSQL
lco='OVERWRITE=YES'
}}}
is OK.

The problem appears when `type=cenroid` is among parameters. It produces
the print-outs and centroids are missing in the output table.

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

#795: v.out.ogr and centroids in GRASS 6.2.1 and PostGIS
----------------------+-----------------------------------------------------
  Reporter: hancar | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: closed
  Priority: normal | Milestone:
Component: default | Version: unspecified
Resolution: fixed | Keywords: v.out.ogr centroid grass postgis gentoo
  Platform: Linux | Cpu: x86-32
----------------------+-----------------------------------------------------
Changes (by mmetz):

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

Comment:

Also happened with current release branch and any OGR format. Fixed in
relbr6 r39682 because I think it is a bug, centroids could not be
exported. Was already fixed in devbr6 and trunk. The memory leaks in
relbr6 persist, these are also only fixed in devbr6 and trunk. Just for
the record, areas are best exported with v.out.ogr -c type=area. Closing
ticket.

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