Bug report #6620

ERROR: column reference "ctid" is ambiguous

Added by Sandro Santilli almost 7 years ago. Updated almost 7 years ago.

Status:Closed
Priority:Normal
Assignee:Sandro Santilli
Category:Data Provider/PostGIS
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed
Crashes QGIS or corrupts data:No Copied to github as #:15805

Description

On TopoGeometry column editing:

Could not commit changes to layer fp

Errors: ERROR: 1 geometries not changed.

  Provider errors:
  PostGIS error while changing geometry values: ERROR:  column reference "ctid" is ambiguous
LINE 1: ...logy.topology t WHERE t.id = topology_id("g") AND ctid=$2 RE...
                                                             ^

I guess the WHERE clause would better use an alias (_qgis_edit.ctid=$2)

History

#1 Updated by Sandro Santilli almost 7 years ago

  • Resolution set to fixed
  • % Done changed from 0 to 100
  • Status changed from Open to Closed

Also available in: Atom PDF