[Qgis-user] PostGIS raster layer filtered by attribute

[Dirk.Pispers at STADT-KOELN.DE]

Hi Thayer,

sorry, I’m very busy at the moment.
It would be very kind, if you open the issue.
Thanks.

Dirk

Von: Thayer Young [mailto:thayeray at yahoo.com]
Gesendet: Dienstag, 8. November 2022 20:37
An: Pispers, Dirk <Dirk.Pispers at STADT-KOELN.DE>; Alessandro Pasotti <apasotti at gmail.com>
Cc: qgis-user at lists.osgeo.org
Betreff: Re: [Qgis-user] PostGIS raster layer filtered by attribute

Hi Dirk,

I have not seen a bug report for this yet. Would you like me to issue one?

I was able to reproduce that the provider for views of raster tables did work in 3.10 but stopped working by 3.14.

-Thayer



On Friday, November 4, 2022 at 08:06:48 AM EDT, Alessandro Pasotti <apasotti at gmail.com<mailto:apasotti at gmail.com>> wrote:


On Fri, Nov 4, 2022 at 12:18 PM <Dirk.Pispers at stadt-koeln.de<mailto:Dirk.Pispers at stadt-koeln.de>> wrote:
>
> Thanks to Thayer and Alesandro.
> I made a lot of tests today. Not all is working, but it's on a good way.
>
> I did not see the "Filter" option on the raster layer in QGIS 3.22 because I searched in the layer properties analog to where the filter is placed for vector layers.
> The filter option works in general but throws a lot of critical errors, when no raster is in  the result of the filter query.
>
> Another solution I tried is to use a view where the raster table is filtered.
> This works in QGIS 3.10 but not in 3.22, where QGIS generates an invalid query against the PostgreSQL catalog when adding the raster layer.
>

Sounds like a bug to me.

Can you file a ticket with all the necessary information and a minimal
SQL dump to reproduce the issue?



--
Alessandro Pasotti
QCooperative:  www.qcooperative.net<http://www.qcooperative.net>
ItOpen:  www.itopen.it<http://www.itopen.it>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20221109/32b9f71b/attachment-0001.htm>