[GRASS-dev] [GRASS GIS] #1510: Querying external PostGIS-layer with multiple geometries crashes wxpython-GUI

GRASS GIS trac at osgeo.org
Thu Dec 15 11:40:53 EST 2011


#1510: Querying external PostGIS-layer with multiple geometries crashes wxpython-
GUI
-------------------------------------------+--------------------------------
 Reporter:  grasslandtom                   |       Owner:  grass-dev@…              
     Type:  defect                         |      Status:  new                      
 Priority:  normal                         |   Milestone:                           
Component:  wxGUI                          |     Version:  6.4.2 RCs                
 Keywords:  wxpython, PostGIS, v.external  |    Platform:  Unspecified              
      Cpu:  Unspecified                    |  
-------------------------------------------+--------------------------------
 steps to reproduce:

 _ import a PostGIS-layer with multiple geometries; something like

 {{{
 v.external dsn='db=mydb' out=vector layer='v_eca_data(coords_gk_em38)'
 }}}

 _ adding the vector-layer to the map in the GUI raises on the console:


 {{{
 ERROR 1: FEHLER:  aktuelle Transaktion wurde abgebrochen, Befehle werden
 bis zum Ende der Transaktion ignoriert

 DBMI-OGR driver error:
 Cannot select:
 select * from v_eca_data(coords_gk_em38)



 GRASS_INFO_WARNING(10090,1): Unable to open select cursor: 'select * from
 v_eca_data(coords_gk_em38)'
 GRASS_INFO_END(10090,1)

 GRASS_INFO_ERROR(10093,1): Unable to describe table
 <v_eca_data(coords_gk_em38)>
 GRASS_INFO_END(10093,1)


 }}}


 _ Clicking on a feature of the layer with the query tool on the map
 crashes the GUI and raises the same error

 It seems to me that the problem is the wrong table name in the query

 {{{
 select * from v_eca_data(coords_gk_em38)
 }}}

 which should be

 {{{
 select * from v_eca_data
 }}}

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



More information about the grass-dev mailing list