Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: column reference "ctid" is ambiguous #15805

Closed
qgib opened this issue Nov 4, 2012 · 1 comment
Closed

ERROR: column reference "ctid" is ambiguous #15805

qgib opened this issue Nov 4, 2012 · 1 comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers
Milestone

Comments

@qgib
Copy link
Contributor

qgib commented Nov 4, 2012

Author Name: Sandro Santilli (@strk)
Original Redmine Issue: 6620
Affected QGIS version: master
Redmine category:data_provider/postgis
Assignee: Sandro Santilli


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)

@qgib
Copy link
Contributor Author

qgib commented Nov 5, 2012

Author Name: Sandro Santilli (@strk)


Fixed by 83f2b2d


  • resolution was changed from to fixed
  • done_ratio was changed from 0 to 100
  • status_id was changed from Open to Closed

@qgib qgib added Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers labels May 24, 2019
@qgib qgib added this to the Version 2.0.0 milestone May 24, 2019
@qgib qgib closed this as completed May 24, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers
Projects
None yet
Development

No branches or pull requests

1 participant