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 .... must be a geometry or geography #60593

Open
2 tasks
strk opened this issue Feb 13, 2025 · 0 comments
Open
2 tasks

ERROR: column .... must be a geometry or geography #60593

strk opened this issue Feb 13, 2025 · 0 comments
Assignees
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! PostGIS data provider

Comments

@strk
Copy link
Contributor

strk commented Feb 13, 2025

What is the bug or the crash?

When opening a TopoGeometry layer from the layers browser an error is printed, like:

Layer face_attributes.omrade: ERROR: column "topo_ar5ngis"."face_attributes"."omrade" must be a geometry or geography

This comes from QGIS query running ST_EstimatedExtent against those columns, whereas such function doesn't exist yet:

src/providers/postgres/qgspostgresconn.cpp:1562 : (PQexec) [21231ms] 2025-02-13T15:45:50 PostGIS[1] Erroneous query: SELECT st_estimatedextent('topo_ar5ngis','face_attributes','omrade') returned 7 [ERROR: column "topo_ar5ngis"."face_attributes"."omrade" must be a geometry or geography

Steps to reproduce the issue

Use the layers browser to select a TopoGeometry layer, in an empty project.

Versions

3.41.0-Master
278eb796fc9

Supported QGIS version

  • I'm running a supported QGIS version according to the roadmap.

New profile

Additional context

No response

@strk strk added Bug Either a bug report, or a bug fix. Let's hope for the latter! PostGIS data provider labels Feb 13, 2025
@strk strk self-assigned this Feb 13, 2025
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! PostGIS data provider
Projects
None yet
Development

No branches or pull requests

1 participant