Bug report #988

PostGIS: allow NULL in numeric columns

Added by Maciej Sieczka - almost 16 years ago. Updated over 14 years ago.

Assignee:Jürgen Fischer
Category:Data Provider
Affected QGIS version: Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied: Resolution:fixed
Crashes QGIS or corrupts data: Copied to github as #:11048


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?



#1 Updated by Steven Mizuno almost 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.

#2 Updated by Jürgen Fischer almost 16 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

#3 Updated by Anonymous over 14 years ago

Milestone Version 0.9.2 deleted

Also available in: Atom PDF