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
_______________________________________________
Pkg-grass-devel mailing list
Pkg-grass-devel@lists.alioth.debian.org
http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-devel
