#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 mlennert): From the error message, it looks like an issue with the length of the SQL statement creating the temporary table (necessary since SQLite does not implement ALTER TABLE DROP COLUMN). But AFAICT, SQLite's query size limit is pretty big (1 000 000 bytes by default). Could you try by altering your local copy to print the column definition: {{{ coltypes = ", ".join(coltypes) +print(coltypes) }}} That would allow to run an SQL statement directly in SQLite to test whether this works. If this is the issue, we could test for the length of the column definition and cut it into several parts if necessary using ALTER TABLE ADD COLUMN with parts 2+. -- Ticket URL: <https://trac.osgeo.org/grass/ticket/3919#comment:2> GRASS GIS <https://grass.osgeo.org>
_______________________________________________ grass-dev mailing list grass-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-dev