graphical identify and select feature do not work on Postgis-sql layer

[qgib]

Author Name: Sebastian Brocks (@beerockxs)
Original Redmine Issue: 21963
Affected QGIS version: 3.6.2
Redmine category:data_provider/postgis

---

I have a SQL-defined postgis layer defined by this statement:

((((SELECT row_number() over () AS uid,* FROM (SELECT generate_series(0, laenge_asb,100) AS station, st_astext(
ST_LineInterpolatePoint(
geometrie,
generate_series(0, laenge_asb,100):: double precision /(laenge_asb)
)
) FROM "erhaltung"."abschnitt" ) AS subq_1 ) ) ) )

abschnitt is a table in my postgis database with a LineStringZM geometry of SRID 4326 stored in the geometrie column that has an integer laenge_asb column

When I try to identify or select features in it by using the identify or select tool, the PostGIS log tab contains this error and no feature is identified or selected:

2019-04-30T14:09:40 WARNING Fetching from cursor qgis_144 failed
Database error: ERROR: Operation on mixed SRID geometries

2019-04-30T14:09:40 WARNING Query: CLOSE qgis_144 returned 7 [ERROR: current transaction is aborted, commands ignored until end of transaction block
]
2019-04-30T14:09:40 WARNING 1 cursor states lost.
SQL: CLOSE qgis_144
Result: 7 (ERROR: current transaction is aborted, commands ignored until end of transaction block
)

[qgib]

Author Name: Sebastian Brocks (@beerockxs)

---

This looks like the issue in issue #14397

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Why are you using @st_astext@?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Sebastian Brocks (@beerockxs)

---

No particular reason, I'm a relative newbie with regard to postgis and QGIS. Changing to st_aswekt makes identify and select work correctly.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Sebastian Brocks wrote:

No particular reason, I'm a relative newbie with regard to postgis and QGIS. Changing to st_aswekt makes identify and select work correctly.

you shouldn't need either @st_astext@ or @st_ewkt@ - the geometry @ST_LineInterpolatePoint@ produces should work as it, but st_astext will essentially just remove the SRID and in turn cause the error.

---

• resolution was changed from to invalid
• status_id was changed from Feedback to Closed