Opened 6 years ago

Closed 6 years ago

#2144 closed defect (fixed)

winGRASS6.4.svn - GUI problems with postgres as database backend

Reported by: hellik Owned by: martinl
Priority: critical Milestone: 6.4.4
Component: wxGUI Version: svn-releasebranch64
Keywords: wingrass, database, postgres, wxgio Cc: grass-dev@…
CPU: x86-64 Platform: MSWindows 7

Description

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@PERMANENT,firestationspg                     
Copy vector <firestations@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@pgtest

vector points are displayed in map display

(11)

v.db.addcol --quiet map=firestationspg@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@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@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@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@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@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@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.)

Change History (3)

comment:1 Changed 6 years ago by martinl

I have tried to reproduce this bug with the recent 6.4.4svn, it seems to work. Could you check the most recent 6.4 version from SVN, please? Thanks.

comment:2 Changed 6 years ago by martinl

Cc: grass-dev@… added
Owner: changed from grass-dev@… to martinl

comment:3 in reply to:  1 Changed 6 years ago by hellik

Resolution: fixed
Status: newclosed

Replying to martinl:

I have tried to reproduce this bug with the recent 6.4.4svn, it seems to work. Could you check the most recent 6.4 version from SVN, please? Thanks.

tested with

System Info                                                                     
GRASS Version: 6.4.4svn                                                         
GRASS SVN Revision: 59305                                                       
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)  

and works. closing ticket

Note: See TracTickets for help on using tickets.