PostGIS: zeros instead of NULLs in a table

[msieczka]

1. Add a numeric column to your PostGIS table (in QGIS or any other client).

2. "Open Table" or "Identify Features" - see QGIS claims there are '0', instead of empty cells (NULL) in the column, although you did not enter them.

Actually these zeros are not there. These *are* NULL cells. Only QGIS displays them bogus.

This way you can't distinguish between cells really containing 0 and NULL. Moreover, you can't fill a NULL cell with a real 0 in QGIS - it will claim nothing changed in the table and won't let you save changes.

r8213

[msieczka]

#988 is related.

[cgsbob]

Replying to msieczka:

#988 is related.

Also look at #962. ​https://trac.osgeo.org/qgis/attachment/ticket/962/nullprob.png illustrates the problem.

[(none)]

Milestone Version 0.9.2 deleted