[GRASS-dev] [GRASS GIS] #3919: db.dropcolumn and v.db.dropcolumn do not drop columns

GRASS GIS trac at osgeo.org
Sun Oct 13 12:58:57 PDT 2019


#3919: db.dropcolumn and v.db.dropcolumn do not drop columns
-------------------------+--------------------------------------------
  Reporter:  veroandreo  |      Owner:  grass-dev@…
      Type:  defect      |     Status:  new
  Priority:  normal      |  Milestone:  7.8.1
 Component:  Database    |    Version:  git-releasebranch78
Resolution:              |   Keywords:  db.dropcolumn, v.db.dropcolumn
       CPU:  x86-64      |   Platform:  Linux
-------------------------+--------------------------------------------

Comment (by neteler):

 Your statement longer than 8192 chars but

 {{{
 include/dbmi.h
 142:#define DB_SQL_MAX      8192
 }}}

 So we need to increase this definition to address the problem with tables
 having a big number of columns with long names.

 Can we just define more chars or are there any sideeffects?

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/3919#comment:4>
GRASS GIS <https://grass.osgeo.org>



More information about the grass-dev mailing list