Bug report #12611

Field calculator forcing creation of new virtual field on PostgreSQL/PostGIS table

Added by mike t almost 9 years ago. Updated almost 9 years ago.

Affected QGIS version:2.8.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:not reproducable
Crashes QGIS or corrupts data:No Copied to github as #:20730


When trying to use the field calculator in 2.6.1 on a PostgreSQL 9.3/PostGIS 2.0 table of points - attempt to calculate a field using the field calculator creates an unnamed int2 virtual field. Unchecking the box for "Create a new field" leaves the "Create virtual field" box grayed out but still checked. When using the field calculator bar at the top of the attribute table, this does not happen and column updates correctly.

Image shows issue with "Create virtual field" checked and grayed out. Table behind show the virtual field created when trying to calculate existing 'lat' field, note the virtual field is the integer version of the attempted latitude $y value.

Thank you,


FieldCalc_Virtualfield.PNG (104 KB) mike t, 2015-04-20 12:09 PM


#1 Updated by Giovanni Manghi almost 9 years ago

  • Status changed from Open to Feedback

I cannot confirm here on qgis master: when switching to "update existing field", even if the "create virtual field" is checked/grayed this has no effect.

#2 Updated by Giovanni Manghi almost 9 years ago

  • Resolution set to not reproducable
  • Status changed from Feedback to Closed

closing for lack of feedback.

Also available in: Atom PDF