[QGIS-trac] Re: [Quantum GIS] #1106: Unable to edit PostGIS layers with case sensitive attribute names

Quantum GIS qgis at qgis.org
Fri May 23 18:19:36 EDT 2008


#1106: Unable to edit PostGIS layers with case sensitive attribute names
--------------------------------------------------------------+-------------
        Reporter:  str238                                     |         Owner:  jef        
            Type:  bug                                        |        Status:  new        
        Priority:  critical: causes crash or data corruption  |     Milestone:  Version 1.0
       Component:  Data Provider                              |       Version:  HEAD       
      Resolution:                                             |      Keywords:             
Platform_version:                                             |      Platform:  All        
        Must_fix:  No                                         |   Status_info:  1          
--------------------------------------------------------------+-------------
Changes (by jef):

  * owner:  nobody => jef
  * status_info:  0 => 1

Comment:

 Please supply an example table which you can't edit.  Following table
 works for me:

 CREATE TABLE "FooBarBaz" (
     "MixedCaseId" integer NOT NULL PRIMARY KEY,
     "MixedCaseAttribute1" integer,
     "MixedCaseAttribute2" character varying,
     "I can't imägine ""attribute names"" that qgis doesn't support" double
 precision
 );
 SELECT
 addgeometrycolumn('public','FooBarBaz','MixedCaseGeometryColumn',4326,'LINESTRING',2);

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


More information about the QGIS-trac mailing list