Opened 16 years ago

Closed 16 years ago

Last modified 15 years ago

#1106 closed bug (fixed)

Unable to edit PostGIS layers with case sensitive attribute names

Reported by: str238 Owned by: jef
Priority: critical: causes crash or data corruption Milestone:
Component: Data Provider Version: Trunk
Keywords: Cc:
Must Fix for Release: No Platform: All
Platform Version: Awaiting user input: yes

Description

There is no way how to edit data in PostGIS tables using the case sensitive attribute names. The only thing needed to be done to fix this is to enclose each attribute name into the double quotation as the table name already is.

Change History (3)

comment:1 by jef, 16 years ago

Awaiting user input: set
Owner: changed from nobody to jef

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);

in reply to:  1 comment:2 by str238, 16 years ago

Resolution: fixed
Status: newclosed

You are absolutelly right. Sorry for submitting non-existing bug. I is probably my sleep deficit. I upgraded to the 1.0 just today, so maybe I mixed in some older stuff. Is that enough to mark this bug resolved as: invalid or wontfix ?

comment:3 by (none), 15 years ago

Milestone: Version 1.0.0

Milestone Version 1.0.0 deleted

Note: See TracTickets for help on using tickets.