Hi Jamille, just for couriosity. How many columns holds the vectorset?
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. 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"). 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. If that could be a feasible approach in your case it might avoid what you described. Best regards. Stefan > Jamille Haarloo <[email protected]> hat am 14. März 2019 um 03:44 > geschrieben: > > Just tested: > > (Wed Mar 13 23:42:59 2019) > > v.db.dropcolumn map=nvTrainingset_new2019@LUP1 > columns=Uitleg2,SegUitleg,x22kcluster,x12kcluster,x17kcluster,x8kcluster,xkcluster > 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 > DOUBLE PRECISION, IDM4_median_nbrstddev DOUBLE PRECIS' > ERROR: Deleting column failed > > On Fri, Mar 8, 2019 at 4:25 PM Markus Metz < > [email protected] mailto:[email protected] > wrote: > > > > > > > > On Thu, Mar 7, 2019 at 6:35 PM Markus Neteler < [email protected] > > mailto:[email protected] > wrote: > > > > > > Hi, > > > > > > On Sat, Feb 16, 2019 at 12:28 AM Jamille Haarloo < > > [email protected] mailto:[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. > > > > The db SQL buffer has been enlarged in trunk r74189 and relbr76 > > r74190. > > > > Please test! > > > > Markus M > > > > > > Markus > > > _______________________________________________ > > > grass-user mailing list > > > [email protected] mailto:[email protected] > > > https://lists.osgeo.org/mailman/listinfo/grass-user > > > > > _______________________________________________ > grass-user mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/grass-user >
_______________________________________________ grass-user mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/grass-user
