#2517: d.vect.thematic won't write grassrgb values, ERROR: You must provide <sql>
or <input> option
-------------------------------------------------+--------------------------
Reporter: jamesp670 | Owner: grass-dev@…
Type: defect | Status: new
Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-releasebranch70
Keywords: d.vect.thematic postgresql grassrgb | Platform: Linux
Cpu: x86-64 |
-------------------------------------------------+--------------------------
The setup:
My uname output:
: GRASS 7.0.0svn (rlis-master-for-seven):~ > uname -a
: Linux login.cluster 2.6.32-431.17.1.el6.x86_64 #1 SMP Wed May 7 23:32:49
UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
I built grass from source, using primarily deps supplied by
: yum install http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/\\
: pgdg-redhat93-9.3-1.noarch.rpm
I just ([2014-12-28 23:08]) did svn up and rebuilt. The build is
painless. GRASS works great, except for this bug. I haven't tried it
with
Spearfish, because getting Spearfish into postgresql seems difficult. I
expect
the bug to show up with any execution of d.vect.thematic -u against a pg-
driven
mapset.
What I expect:
When I run this command, which was constructed using the d.vect.thematic
GUI:
: d.vect.thematic -f -s --verbose
map=tract2010censusdp1_clipped_02@PERMANENT column=popden10
themetype=graduated_colors themecalc=custom_breaks breakpoints="0 500 1000
1500 2000 5000 10000 15000 20000 25000" colorscheme=green-red monitor=none
-u
I expect no errors, and colors to be written to grassrgb thanks to the
presence of the -u flag.
What I get:
: GRASS 7.0.0svn (rlis-master-for-seven):~ > d.vect.thematic -f -s
--verbose map=tract2010censusdp1_clipped_02@PERMANENT column=popden10
themetype=graduated_colors themecalc=custom_breaks breakpoints="0 500 1000
1500 2000 5000 10000 15000 20000 25000"$
:
: Creating column 'grassrgb' in table <tract2010censusdp1_clipped_02>
: ERROR: You must provide <sql> or <input> option
: ^GTraceback (most recent call last):
: File "/opt/yum-packages-installed-on-the-head-
node/tmp/local/grass-7.0.0svn/scripts/d.vect.thematic", line 1105, in
<module>
: main()
: File "/opt/yum-packages-installed-on-the-head-
node/tmp/local/grass-7.0.0svn/scripts/d.vect.thematic", line 316, in main
: grass.write_command('db.execute', database = database, driver =
driver, stdin = sql)
: File "/opt/yum-packages-installed-on-the-head-
node/tmp/local/grass-7.0.0svn/etc/python/grass/script/core.py", line 483,
in write_command
: return handle_errors(returncode, returncode, args, kwargs)
: File "/opt/yum-packages-installed-on-the-head-
node/tmp/local/grass-7.0.0svn/etc/python/grass/script/core.py", line 308,
in handle_errors
: returncode=returncode)
: grass.exceptions.CalledModuleError: Module run None ['db.execute',
'stdin=ALTER TABLE tract2010censusdp1_clipped_02 ADD COLUMN grassrgb
varchar(11)', 'driver=pg', 'database=host=node01,dbname=rlis-gis'] ended
with error
: Process ended with non-zero return code 1. See errors in the (error)
output.
: GRASS 7.0.0svn (rlis-master-for-seven):~ >
Thank you!
--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2517>
GRASS GIS <http://grass.osgeo.org>