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

[Francesco P. Lovergine]

On Fri, Jul 27, 2007 at 05:35:14PM +0200, Didrik Pinte wrote:
> 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
> 

This is almost for sure an upstream issue.

-- 
Francesco P. Lovergine