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

[Didrik Pinte]

Package: grass
Version: 6.2.2-1
Severity: normal


Hi,

I'm not sure if it has to be forwarded upstream or not but I have the following
issue since 6.2.2 update :

this line does not work anymore :
v.db.update map=base_cells column=pprivate value="area_new * b_pump_priva / b_area_tot"

giving the following error : 

---------------------------------------------------------------------------------------
DBMI-Postgres driver error:
Cannot execute: 
UPDATE base_cells SET pprivate='area_new * b_pump_priva / b_area_tot'

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


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

but if I do this :

echo 'update base_cells set pprivate=b_pump_priva*area_new/b_area_tot' | db.execute


it runs fine ...

The script was running correctly with the previous 6.2.1 version. 

What can I do ?

Didrik

-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 2.6.22-1-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages grass depends on:
ii  fftw3                   3.1.2-2          library for computing Fast Fourier
ii  gnome-terminal [x-termi 2.18.1-1         The GNOME 2 terminal emulator appl
ii  lesstif2                1:0.95.0-2+b1    OSF/Motif 2.1 implementation relea
ii  libc6                   2.6-4            GNU C Library: Shared libraries
ii  libfreetype6            2.3.5-1+b1       FreeType 2 font engine, shared lib
ii  libgcc1                 1:4.2.1-0        GCC support library
ii  libgdal1-1.4.0          1.4.1-6+b3       Geospatial Data Abstraction Librar
ii  libgl1-mesa-swx11 [libg 6.5.2-7          A free implementation of the OpenG
ii  libglu1-mesa [libglu1]  6.5.2-7          The OpenGL utility library (GLU)
ii  libice6                 2:1.0.3-3        X11 Inter-Client Exchange library
ii  libmysqlclient15off     5.0.45-1         MySQL database client library
ii  libncurses5             5.6+20070716-1   Shared libraries for terminal hand
ii  libpng12-0              1.2.15~beta5-2   PNG library - runtime
ii  libpq5                  8.2.4-2          PostgreSQL C client library
ii  libreadline5            5.2-3            GNU readline and history libraries
ii  libsm6                  2:1.0.3-1+b1     X11 Session Management library
ii  libsqlite3-0            3.3.17-1         SQLite 3 shared library
ii  libstdc++6              4.2.1-0          The GNU Standard C++ Library v3
ii  libtiff4                3.8.2-7          Tag Image File Format (TIFF) libra
ii  libx11-6                2:1.0.3-7        X11 client-side library
ii  libxext6                1:1.0.3-2        X11 miscellaneous extension librar
ii  libxmu6                 1:1.0.3-1        X11 miscellaneous utility library
ii  libxt6                  1:1.0.5-3        X11 toolkit intrinsics library
ii  proj                    4.5.0-2          Cartographic projection filter and
ii  tcl8.4                  8.4.15-1         Tcl (the Tool Command Language) v8
ii  tk8.4                   8.4.15-1         Tk toolkit for Tcl and X11, v8.4 -
ii  unixodbc                2.2.11-15        ODBC tools libraries
ii  xterm [x-terminal-emula 228-1            X terminal emulator
ii  zlib1g                  1:1.2.3.3.dfsg-5 compression library - runtime

grass recommends no packages.

-- no debconf information