[QGIS-trac] Re: [Quantum GIS] #2733: fTools Add geometry column fails to add XCOORD if source is GPX file or PostGIS Layer (was: fTools Add geometry column fails to add XCOORD if source is GPX file)

[Quantum GIS]

#2733: fTools Add geometry column fails to add XCOORD if source is GPX file or
PostGIS Layer
------------------------------------------------+---------------------------
   Reporter:  marisn                            |              Owner:  cfarmer      
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.6.0
  Component:  Python plugins and bindings       |            Version:  Trunk        
   Keywords:  ftools                            |   Platform_version:               
   Platform:  All                               |           Must_fix:  Yes          
Status_info:  0                                 |  
------------------------------------------------+---------------------------
Changes (by hdus):

 * cc: horst.duester@… (added)
  * must_fix:  No => Yes


Comment:

 I found the same behaviour with PostGIS layers as well. The bug depends on
 the position of the geometry column in the column-list.

 With the following POINT table-definition, geometry column at the
 beginning of the columns list:

 {{{
 CREATE TABLE test1
 (
   id serial NOT NULL,
   wkb_geometry geometry,
   feld1 text,
   feld2 text,
   feld3 integer,
   CONSTRAINT test1_pkey PRIMARY KEY (id)
 )
 }}}

 only the YCOORD column will be exported.


 With the following POINT table-definition, with geometry at the end of the
 columns list:

 {{{
 CREATE TABLE test1
 (
   id serial NOT NULL,
   feld1 text,
   feld2 text,
   feld3 integer,
   wkb_geometry geometry
   CONSTRAINT test1_pkey PRIMARY KEY (id)
 )
 }}}

 all columns XCOORD and YCOORD will be exported fine.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2733#comment:4>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats