What is the bug or the crash?

When viewing a PostGIS raster layer in QGIS the Layer Properties / Transparency NoData value setting doesn't seem to be working when querying the layer. This also has a knock-on effect on symbology.

Steps to reproduce the issue

Using a postgres database with postgis & postgis_raster extentions installed, load the following raster into postgres:

raster_example.tif

raster2pgsql -s 4326 -t 100x100 -q -c -F -I -C -M -Y "C:\GIS\Data\raster_example.tif" test.raster_example | psql -U postgres -d postgis_35_sample -h localhost -p 5432

In QGIS compare the nodata behaviour of the file-based raster with the postgres raster.

Versions

PostgreSQL 16.8
PostGIS 3.5

Supported QGIS version

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

New profile

• I tried with a new QGIS profile

Additional context

No response