[GRASS-dev] [GRASS GIS] #3444: v.concave.hull -script type definition for table column not compatible with PostgreSQL

#3444: v.concave.hull -script type definition for table column not compatible with
PostgreSQL
----------------------------------------+-------------------------
Reporter: harrik | Owner: grass-dev@…
     Type: defect | Status: new
Priority: normal | Milestone:
Component: Addons | Version: 7.2.0
Keywords: v.concave.hull, PostgreSQL | CPU: Unspecified
Platform: Unspecified |
----------------------------------------+-------------------------
Very simple. The GRASS Addon 'v.concave.hull' has a column definition that
does not work with the PostgreSQL backend:

{{{
Line 98:
grass.run_command('v.db.addtable', map = out_lines,
                    col = 'cat integer,length double', quiet = True)
}}}

That gives an error, whereas the simple replacement of `length double`
with `length double precision` makes the script run:

{{{
grass.run_command('v.db.addtable', map = out_lines,
                       col = 'cat integer,length double precision', quiet =
True)
}}}

This should run at least with the sql-based backends since based on MySQL
and SQLite documentation the `double precision` is the full type name
anyway, but I do not know about DBF. But from what I've understood, the
use of DBF is not recommended any more anyway.

I could easily fix this myself, but I do not have write access to sources.

Harri

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

#3444: v.concave.hull -script type definition for table column not compatible with
PostgreSQL
--------------------------+----------------------------------------
  Reporter: harrik | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone:
Component: Addons | Version: 7.2.0
Resolution: | Keywords: v.concave.hull, PostgreSQL
       CPU: Unspecified | Platform: Unspecified
--------------------------+----------------------------------------

Comment (by mlennert):

Fixed in r71741. Please reinstall the extension and test.

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

#3444: v.concave.hull -script type definition for table column not compatible with
PostgreSQL
--------------------------+----------------------------------------
  Reporter: harrik | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone:
Component: Addons | Version: 7.2.0
Resolution: | Keywords: v.concave.hull, PostgreSQL
       CPU: Unspecified | Platform: Unspecified
--------------------------+----------------------------------------

Comment (by harrik):

Works now.

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

#3444: v.concave.hull -script type definition for table column not compatible with
PostgreSQL
--------------------------+----------------------------------------
  Reporter: harrik | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: normal | Milestone:
Component: Addons | Version: 7.2.0
Resolution: fixed | Keywords: v.concave.hull, PostgreSQL
       CPU: Unspecified | Platform: Unspecified
--------------------------+----------------------------------------
Changes (by martinl):

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

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