[GRASS-dev] [GRASS GIS] #2144: winGRASS6.4.svn - GUI problems with postgres as database backend

[GRASS GIS]

#2144: winGRASS6.4.svn - GUI problems with postgres as database backend
-------------------------------------------------+--------------------------
 Reporter:  hellik                               |       Owner:  grass-dev@…              
     Type:  defect                               |      Status:  new                      
 Priority:  critical                             |   Milestone:  6.4.4                    
Component:  wxGUI                                |     Version:  svn-releasebranch64      
 Keywords:  wingrass, database, postgres, wxgio  |    Platform:  MSWindows 7              
      Cpu:  x86-64                               |  
-------------------------------------------------+--------------------------
 tested with

 {{{
 System Info
 GRASS Version: 6.4.4svn
 GRASS SVN Revision: 58440
 GIS Library Revision: 50937 (2012-02-25)
 GDAL/OGR: 1.10.1
 PROJ4: Rel. 4.8.0, 6 March 2012
 Python: 2.7.4
 wxPython: 2.8.12.1
 Platform: Windows-7-6.1.7601-SP1 (OSGeo4W)
 }}}

 {{{
 postgresql-9.3.2-1-windows-x64
 }}}

 {{{
 nc_spm_08
 }}}

 (1)

 new database in postgres by pgAdminIII: grassgisdb

 (2)

 new mapset in nc_spm_08: pgtest

 (3)

 {{{
 db.connect --verbose driver=pg database=host=localhost,dbname=grassgisdb
 }}}

 (4)

 {{{
 db.login --verbose driver=pg database=host=localhost,dbname=grassgisdb
 user=xxxxxxx password=xxxxxx
 }}}

 (5)

 {{{
 db.connect -p
 driver:pg
 database:host=localhost,dbname=grassgisdb
 schema:
 group:
 }}}

 (6)

 {{{
 g.copy --verbose vect=firestations at PERMANENT,firestationspg
 Copy vector <firestations at PERMANENT> to current mapset as <firestationspg>
 }}}

 (7)

 {{{
 g.list type=vect
 ----------------------------------------------
 vector Dateien im Mapset <pgtest> vorhanden:
 firestationspg
 }}}

 check by pgAdminIII: the attribute table of firestationspg is in the
 postgres-database grassgisdb

 (8)

 db.tables-wxgui

 {{{
 db.tables -p --verbose
 information_schema.sql_features
 information_schema.sql_implementation_info
 information_schema.sql_languages
 information_schema.sql_packages
 information_schema.sql_parts
 information_schema.sql_sizing
 information_schema.sql_sizing_profiles
 }}}

 (9)

 db.columns-wxgui: no firestationspg attribute table choosable, only table
 mentioned in (8)

 (10)

 {{{
 d.vect map=firestationspg at pgtest
 }}}

 vector points are displayed in map display

 (11)

 {{{
 v.db.addcol --quiet map=firestationspg at pgtest columns=hk int
 (Sun Dec 15 01:36:14 2013) Befehl ausgeführt (4 Sek)
 (Sun Dec 15 01:38:32 2013)
 v.db.addcol --verbose map=firestationspg at pgtest columns=hk2 int
 (Sun Dec 15 01:38:35 2013) Befehl ausgeführt (3 Sek)
 }}}

 columns are added

 (12)

 v.db.update-wxgui

 {{{
 v.db.update map=firestationspg at pgtest column=<required>
 }}}

 columns added by (11) aren't choosable in the v.db.update-wxgui

 (13)

 v.db.update by command line ok

 {{{
 v.db.update map=firestationspg at pgtest column=hk value=1
 (Sun Dec 15 01:42:17 2013) Befehl ausgeführt (5 Sek)
 (Sun Dec 15 01:42:44 2013)
 v.db.update --verbose map=firestationspg at pgtest column=hk2 value=1
 SQL: "UPDATE firestationspg SET hk2=1"
 (Sun Dec 15 01:42:47 2013) Befehl ausgeführt (3 Sek)
 }}}

 (14)

 v.db.dropcol-wxgui

 {{{
 v.db.dropcol map=firestationspg at pgtest column=<required>
 }}}

 columns added by (11) aren't choosable in the v.db.dropcol-wxgui

 (15)

 v.db.update by command line ok

 {{{
 v.db.dropcol --verbose map=firestationspg at pgtest column=hk2
 (Sun Dec 15 01:47:24 2013) Befehl ausgeführt (3 Sek)
 }}}

 (16)

 map query a point of firestationspg in map display => wingrass6.4.4svn
 crashes, not only gui, also whole session

 (17)

 open attribute table of firestationspg by right click => wingrass6.4.4svn
 crashes, not only gui, also whole session

 summary:

 (A) postgres as database backend '''is''' working with actions from the
 (wxgui)command console in wingrass6.4.4svn

 (B) postgres as database backend '''is not''' working within the wxgui of
 different actions (attribute table manager, map query, v.db.dropcol-wxgui,
 etc.)

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/2144>
GRASS GIS <http://grass.osgeo.org>