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

#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@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.)

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

#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 |
-------------------------------------------------+--------------------------

Comment(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.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2144#comment:1&gt;
GRASS GIS <http://grass.osgeo.org>

#2144: winGRASS6.4.svn - GUI problems with postgres as database backend
-------------------------------------------------+--------------------------
Reporter: hellik | Owner: martinl
     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 |
-------------------------------------------------+--------------------------
Changes (by martinl):

* cc: grass-dev@… (added)
  * owner: grass-dev@… => martinl

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2144#comment:2&gt;
GRASS GIS <http://grass.osgeo.org>

#2144: winGRASS6.4.svn - GUI problems with postgres as database backend
--------------------------+-------------------------------------------------
  Reporter: hellik | Owner: martinl
      Type: defect | Status: closed
  Priority: critical | Milestone: 6.4.4
Component: wxGUI | Version: svn-releasebranch64
Resolution: fixed | Keywords: wingrass, database, postgres, wxgio
  Platform: MSWindows 7 | Cpu: x86-64
--------------------------+-------------------------------------------------
Changes (by hellik):

  * status: new => closed
  * resolution: => fixed

Comment:

Replying to [comment:1 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

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/2144#comment:3&gt;
GRASS GIS <http://grass.osgeo.org>