<div dir="ltr"><div dir="ltr">Just tested:<div><br></div><div><div>(Wed Mar 13 23:42:59 2019)                                                      </div><div>v.db.dropcolumn map=nvTrainingset_new2019@LUP1 columns=Uitleg2,SegUitleg,x22kcluster,x12kcluster,x17kcluster,x8kcluster,xkcluster</div><div>ERROR: Error while executing: 'CREATE TEMPORARY TABLE nvTrainingset_new2019_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_nbrmean</div><div>DOUBLE PRECISION, IDM4_median_nbrstddev DOUBLE PRECIS'</div><div>ERROR: Deleting column failed</div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Mar 8, 2019 at 4:25 PM Markus Metz <<a href="mailto:markus.metz.giswork@gmail.com">markus.metz.giswork@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br><br>On Thu, Mar 7, 2019 at 6:35 PM Markus Neteler <<a href="mailto:neteler@osgeo.org" target="_blank">neteler@osgeo.org</a>> wrote:<br>><br>> Hi,<br>><br>> On Sat, Feb 16, 2019 at 12:28 AM Jamille Haarloo <<a href="mailto:j.r.haarloo@gmail.com" target="_blank">j.r.haarloo@gmail.com</a>> wrote:<br>> ><br>> > Dear Grass community,<br>> ><br>> > 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.<br>> ><br>> > output:<br>> > v.db.dropcolumn map=nvTrainingset_test2019_clean@LUP1 columns=code<br>> > 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<br>> > brmean DOUBLE PRECISION, IDM4_median_nbrstddev DOUBLE'<br>> > ERROR: Deleting column failed<br>> ><br>> > Any suggestions?<br>><br>> I used "wc -c" to count the length of the string: it is 4096 characters.<br>><br>> Which DB driver do you use? It seems to be a limitation in the driver<br>> communication, i.e. the buffer is limited.<br><div><br></div><div>The db SQL buffer has been enlarged in trunk r74189 and relbr76 r74190.</div><div><br></div><div>Please test!</div><div><br></div><div>Markus M<br></div><div>></div>> Markus<br>> _______________________________________________<br>> grass-user mailing list<br>> <a href="mailto:grass-user@lists.osgeo.org" target="_blank">grass-user@lists.osgeo.org</a><br>> <a href="https://lists.osgeo.org/mailman/listinfo/grass-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/grass-user</a></div>
</blockquote></div>