[DebianGIS-dev] Bug#434897: v.db.update with 6.2.2 patch

[Didrik Pinte]

On Wed, 2007-08-08 at 22:40 +0200, Markus Neteler wrote:
> Hi Didrik,
> 
> oh - the --q in my patch should have been -q.
> 
> Attached the revised patch. Due to failing of v.info
> the rest also fails (say, the new trick fails to
> work around the indicated problem).
> 
> Let me know,
> Markus
> 

Hi Markus,

The patch does not work :

----------------------------------------------------------------------------
GRASS 6.2.2 (ALMERIA):~/projets/ucl/alert/alertprog/grass > v.db.update
map=base_cells column=irrigated value="b_irr_area * area_new\
/ b_area_tot"
Sorry, <q> is not a valid flag

Description:
 Outputs basic information about a user-specified vector map layer.

Keywords:
 vector

Usage:
 v.info [-hcg] map=name [layer=value]

Flags:
  -h   Print vector history instead of info
  -c   Print types/names of table columns for specified layer instead of
info
  -g   Print vector map region only

Parameters:
    map   Name of input vector map
  layer   Layer number
          default: 1
DBMI-Postgres driver error:
Cannot execute: 
UPDATE base_cells SET irrigated='b_irr_area * area_new/ b_area_tot'

ERROR:  invalid input syntax for type double precision: "b_irr_area *
area_new/ b_area_tot"


ERROR: Error while executing: "UPDATE base_cells SET
irrigated='b_irr_area
       * area_new/ b_area_tot'
       "
----------------------------------------------------------------------------

Just removing the -q in the v.info line solved the problem and make it
work. I've attached the running version.

Didrik
-------------- next part --------------
A non-text attachment was scrubbed...
Name: v.db.update.patch
Type: text/x-patch
Size: 1832 bytes
Desc: not available
Url : http://lists.alioth.debian.org/pipermail/pkg-grass-devel/attachments/20070820/31ed06ae/attachment-0001.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.alioth.debian.org/pipermail/pkg-grass-devel/attachments/20070820/31ed06ae/attachment-0001.pgp