On Tue, Feb 4, 2020 at 5:02 PM Jason Carlson <ja...@starlandcounty.com> wrote:
> Can anyone else confirm this before I submit it? > Can you please check latest master builds first? I've done a couple of fixes in the past few days that might have an impact on this issue. If the issue is still there, please file a ticket and attach a small SQL dump and a QGS project to reproduce the issue. > After I upgraded from 3.10.1 to 3.10.2 I noticed an issue that it no > longer handles null values correctly when updating records in PostGIS. > > I rolled back to version 3.10.1 and the issue goes away. > > Here is more detail: > I have some PostgreSQL tables that have fields that can be NULL or text > but I have check constraint in place saying it has to be NULL or one of a > list of specific strings. > > In 3.10.1 if I go to edit a record that has some fields set as NULL, when > the QGIS attribute form loads for editing, it shows those fields as NULL > inside the text field (they can be text or null). I can make changes to any > fields and save and the NULL fields remain as NULL. > > In 3.10.2 if I go to edit the same record, the QGIS attribute form when > displayed for editing the record does not show those fields as being NULL > but an empty string. When I submit changes, any fields that should still be > NULL are not being submitted as NULL as I get a check constraint error > saying it doesn't fit the criteria. I've tried entering into those fields > manually as NULL or 'NULL' or "NULL" and a dozen or so other guesses and it > still fails. > > Again, if I roll back to version 3.10.1 it works as it has on many > previous versions all the way back to 2.8 > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user -- Alessandro Pasotti w3: www.itopen.it
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
