Hi, On Sat, Feb 16, 2019 at 12:28 AM Jamille Haarloo <[email protected]> wrote: > > Dear Grass community, > > I don't have any success with removal of columns from a vector file I am > working with, while adding columns has not been a problem. > > output: > v.db.dropcolumn map=nvTrainingset_test2019_clean@LUP1 columns=code > ERROR: Error while executing: 'CREATE TEMPORARY TABLE > nvTrainingset_test2019_clean_backup(cat INTEGER, compact_circle DOUBLE > PRECISION, DV2_mean DOUBLE PRECISION, DV2_stddev DOUBLE PRECISION, > DV2_variance DOUBLE PRECISION, DV2_coeff_var DOUBLE PRECISION, > DV2_first_quart DOUBLE PRECISION, DV2_median DOUBLE PRECISION, > DV2_third_quart DOUBLE PRECISION, DV2_perc_90 DOUBLE PRECISION, DV4_mean > DOUBLE PRECISION, DV4_stddev DOUBLE PRECISION, DV4_variance DOUBLE PRECISION, > DV4_coeff_var DOUBLE PRECISION, DV4_first_quart DOUBLE PRECISION, DV4_median > DOUBLE PRECISION, DV4_third_quart DOUBLE PRECISION, DV4_perc_90 DOUBLE > PRECISION, IDM2_mean DOUBLE PRECISION, IDM2_stddev DOUBLE PRECISION, > IDM2_variance DOUBLE PRECISION, IDM2_coeff_var DOUBLE PRECISION, > IDM2_first_quart DOUBLE PRECISION, IDM2_median DOUBLE PRECISION, > IDM2_third_quart DOUBLE PRECISION, IDM2_perc_90 DOUBLE PRECISION, IDM4_mean > DOUBLE PRECISION, IDM4_stddev DOUBLE PRECISION, IDM4_variance DOUBLE > PRECISION, IDM4_coeff_var DOUBLE PRECISION, IDM4_first_quart DOUBLE > PRECISION, IDM4_median DOUBLE PRECISION, IDM4_third_quart DOUBLE PRECISION, > IDM4_perc_90 DOUBLE PRECISION, W2_mean DOUBLE PRECISION, W2_stddev DOUBLE > PRECISION, W2_variance DOUBLE PRECISION, W2_coeff_var DOUBLE PRECISION, > W2_first_quart DOUBLE PRECISION, W2_median DOUBLE PRECISION, W2_third_quart > DOUBLE PRECISION, W2_perc_90 DOUBLE PRECISION, W4_mean DOUBLE PRECISION, > W4_stddev DOUBLE PRECISION, W4_variance DOUBLE PRECISION, W4_coeff_var DOUBLE > PRECISION, W4_first_quart DOUBLE PRECISION, W4_median DOUBLE PRECISION, > W4_third_quart DOUBLE PRECISION, W4_perc_90 DOUBLE PRECISION, neighbors_count > DOUBLE PRECISION, compact_circle_nbrmean DOUBLE PRECISION, > compact_circle_nbrstddev DOUBLE PRECISION, DV2_mean_nbrmean DOUBLE PRECISION, > DV2_mean_nbrstddev DOUBLE PRECISION, DV2_stddev_nbrmean DOUBLE PRECISION, > DV2_stddev_nbrstddev DOUBLE PRECISION, DV2_variance_nbrmean DOUBLE PRECISION, > DV2_variance_nbrstddev DOUBLE PRECISION, DV2_coeff_var_nbrmean DOUBLE > PRECISION, DV2_coeff_var_nbrstddev DOUBLE PRECISION, DV2_first_quart_nbrmean > DOUBLE PRECISION, DV2_first_quart_nbrstddev DOUBLE PRECISION, > DV2_median_nbrmean DOUBLE PRECISION, DV2_median_nbrstddev DOUBLE PRECISION, > DV2_third_quart_nbrmean DOUBLE PRECISION, DV2_third_quart_nbrstddev DOUBLE > PRECISION, DV2_perc_90_nbrmean DOUBLE PRECISION, DV2_perc_90_nbrstddev DOUBLE > PRECISION, DV4_mean_nbrmean DOUBLE PRECISION, DV4_mean_nbrstddev DOUBLE > PRECISION, DV4_stddev_nbrmean DOUBLE PRECISION, DV4_stddev_nbrstddev DOUBLE > PRECISION, DV4_variance_nbrmean DOUBLE PRECISION, DV4_variance_nbrstddev > DOUBLE PRECISION, DV4_coeff_var_nbrmean DOUBLE PRECISION, > DV4_coeff_var_nbrstddev DOUBLE PRECISION, DV4_first_quart_nbrmean DOUBLE > PRECISION, DV4_first_quart_nbrstddev DOUBLE PRECISION, DV4_median_nbrmean > DOUBLE PRECISION, DV4_median_nbrstddev DOUBLE PRECISION, > DV4_third_quart_nbrmean DOUBLE PRECISION, DV4_third_quart_nbrstddev DOUBLE > PRECISION, DV4_perc_90_nbrmean DOUBLE PRECISION, DV4_perc_90_nbrstddev DOUBLE > PRECISION, IDM2_mean_nbrmean DOUBLE PRECISION, IDM2_mean_nbrstddev DOUBLE > PRECISION, IDM2_stddev_nbrmean DOUBLE PRECISION, IDM2_stddev_nbrstddev DOUBLE > PRECISION, IDM2_variance_nbrmean DOUBLE PRECISION, IDM2_variance_nbrstddev > DOUBLE PRECISION, IDM2_coeff_var_nbrmean DOUBLE PRECISION, > IDM2_coeff_var_nbrstddev DOUBLE PRECISION, IDM2_first_quart_nbrmean DOUBLE > PRECISION, IDM2_first_quart_nbrstddev DOUBLE PRECISION, IDM2_median_nbrmean > DOUBLE PRECISION, IDM2_median_nbrstddev DOUBLE PRECISION, > IDM2_third_quart_nbrmean DOUBLE PRECISION, IDM2_third_quart_nbrstddev DOUBLE > PRECISION, IDM2_perc_90_nbrmean DOUBLE PRECISION, IDM2_perc_90_nbrstddev > DOUBLE PRECISION, IDM4_mean_nbrmean DOUBLE PRECISION, IDM4_mean_nbrstddev > DOUBLE PRECISION, IDM4_stddev_nbrmean DOUBLE PRECISION, IDM4_stddev_nbrstddev > DOUBLE PRECISION, IDM4_variance_nbrmean DOUBLE PRECISION, > IDM4_variance_nbrstddev DOUBLE PRECISION, IDM4_coeff_var_nbrmean DOUBLE > PRECISION, IDM4_coeff_var_nbrstddev DOUBLE PRECISION, > IDM4_first_quart_nbrmean DOUBLE PRECISION, IDM4_first_quart_nbrstddev DOUBLE > PRECISION, IDM4_median_n > brmean DOUBLE PRECISION, IDM4_median_nbrstddev DOUBLE' > ERROR: Deleting column failed > > Any suggestions?
I used "wc -c" to count the length of the string: it is 4096 characters. Which DB driver do you use? It seems to be a limitation in the driver communication, i.e. the buffer is limited. Markus _______________________________________________ grass-user mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/grass-user
