Bug report #22127

When clearing a field, default value is not applied, instead QGIS attepts to insert the UI text hint

Added by Cory Albrecht over 4 years ago. Updated over 4 years ago.

Category:Data Provider/PostGIS
Affected QGIS version:3.6.2 Regression?:No
Operating System:Ubuntu 18.10 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29938


Instead of generating a new default value, QGIS tries to insert the hint used to show what will be generated.

2019-05-22T20:47:09     WARNING    Erroneous query: UPDATE "Balance of Power"."timeline-countries" SET "feature_uuid"='uuid_generate_v4()',"country_uuid"='uuid_generate_v4()',"alternate_name"=E'{}',"full_name"=E'{}' WHERE "feature_uuid"::text='59f16d38-2b77-4b3f-8cad-436026d3b5e7' returned 7 [ERROR: invalid input syntax for uuid: "uuid_generate_v4()" 
             LINE 1: ...of Power"."timeline-countries" SET "feature_uuid"='uuid_gene...

Noosa 3.6.2-6f76857

Screenshot from 2019-05-22 20-48-26.png (132 KB) Cory Albrecht, 2019-05-23 02:48 AM


#1 Updated by Giovanni Manghi over 4 years ago

  • Status changed from Open to Feedback

Please provide detailed steps to replicate.

Also available in: Atom PDF