[QGIS-trac] Re: [Quantum GIS] #1876: PostgreSQL text fields become zero-length strings when blanked on attribute update edits from QGIS

[Quantum GIS]

#1876: PostgreSQL text fields become zero-length strings when blanked on attribute
update edits from QGIS
-----------------------------------------------------+----------------------
        Reporter:  mwtoews                           |         Owner:  jef          
            Type:  bug                               |        Status:  new          
        Priority:  major: does not work as expected  |     Milestone:  Version 1.2.0
       Component:  Data Provider                     |       Version:  HEAD         
      Resolution:                                    |      Keywords:               
Platform_version:                                    |      Platform:  All          
        Must_fix:  No                                |   Status_info:  0            
-----------------------------------------------------+----------------------
Changes (by jef):

  * owner:  nobody => jef

Comment:

 Replying to [ticket:1876 mwtoews]:
 > Strictly speaking, this is not a bug, but is in a grey-area leaning
 toward "feature".

 Well, I consider it a bug.  1. NULL and an empty string are different
 values. And 2. if you don't touch the value, the value should stay the
 same.

 I already fixed that once back in r8217.   In r11392 I fixed it again.
 When editing empty strings are considered NULL in case of numeric values.
 For strings the literate string {{{NULL}}} is considered NULL.

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