<!DOCTYPE html>
<html><head>
<meta charset="UTF-8">
</head><body><p>Hi Jamille,<br></p><p>just for couriosity. How many columns holds the vectorset?<br></p><p>In fact from a database perspective I would rather choose to keep only geometry-related data or metadata direct with the vectorset. Concerning the column names I would suspect there rather should be a bunch of attribute tables to join to the vectorset. From a database perspective one usualy tries to normalize the database structure, i.e. break down tables to avoid redundancies.<br></p><p>For example names like DV2_median, DV4_median, IDM2_median, IDM4_median seem to me as you could create 4 separate tables each with a column "median" (and other columns like "first_quart" an so on). Then you join the tables by a key-column (most probably "cat").<br></p><p>In that case you avoid probable redundancies and keep tables small which results in avoiding DB-driver issues because of to small query-(/command-)buffer, respective datatype restrictions (of the buffer). Which seems the cause of your actual troubles.<br></p><p>If that could be a feasible approach in your case it might avoid what you described.<br></p><p>Best regards.<br></p><p>Stefan<br></p><blockquote type="cite">Jamille Haarloo <j.r.haarloo@gmail.com> hat am 14. März 2019 um 03:44 geschrieben: <br> <br><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="ox-7528b2c933-gmail_quote"><div dir="ltr" class="ox-7528b2c933-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><div dir="ltr"><br> <br>On Thu, Mar 7, 2019 at 6:35 PM Markus Neteler < <a href="mailto:neteler@osgeo.org" target="_blank" rel="noopener">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" rel="noopener">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" rel="noopener">grass-user@lists.osgeo.org</a> <br>> <a href="https://lists.osgeo.org/mailman/listinfo/grass-user" target="_blank" rel="noopener">https://lists.osgeo.org/mailman/listinfo/grass-user</a><br></div></blockquote></div>_______________________________________________ <br>grass-user mailing list <br>grass-user@lists.osgeo.org <br>https://lists.osgeo.org/mailman/listinfo/grass-user</blockquote></body></html>