Opened 16 years ago

Closed 16 years ago

Last modified 15 years ago

#988 closed bug (fixed)

PostGIS: allow NULL in numeric columns

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


Related to #987:

  1. Edit a PostGIS table cell in a numeric column trying to make it NULL. Save changes.


ERROR:  invalid input syntax for type double precision: ""

Same happens at saving changes when quiting digitizer.

Is there a reason QGIS doesn't allow null numeric table cells?


Change History (4)

comment:1 by jef, 16 years ago

Owner: changed from nobody to jef

comment:2 by smizuno, 16 years ago

The problem with saving the null values is when sending the INSERT or UPDATE statement to the PostgreSQL database the value is quoted, which is okay for numbers and must be for special values like 'NAN' or 'Infinity', but quotes with zero or more spaces is not accepted. The value needs to be NULL (no quotes) or the comma separators with nothing but whitespace between.

comment:3 by jef, 16 years ago

Resolution: fixed
Status: newclosed

comment:4 by (none), 15 years ago

Milestone: Version 0.9.2

Milestone Version 0.9.2 deleted

Note: See TracTickets for help on using tickets.