Skip to content

Rendering of PostGIS rasters ignores Transparency NoData value setting #63171

Description

@kewgis

What is the bug or the crash?

When I try to render a PostGIS raster the Transparency NoData setting is ignored.

Recording.2025-09-12.140738.mp4

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

Check the Transparency NoData setting and then try applying different rendering options.

Versions

QGIS version3.44.2-Solothurn
QGIS code revisionf30453dede3
 
Libraries
Qt version5.15.13
Python version3.12.11
GDAL version3.11.3 — Eganville
PROJ version9.6.2
EPSG Registry database versionv12.013 (2025-05-26)
GEOS version3.13.1-CAPI-1.19.2
SQLite version3.50.4
PDAL version2.9.0
PostgreSQL client version17.3
SpatiaLite version5.1.0
QWT version6.3.0
QScintilla2 version2.14.1
OS versionWindows 11 Version 2009
 
Active Python plugins
db_manager0.1.20
grassprovider2.12.99
MetaSearch0.3.6
processing2.12.99

PostgreSQL 16.8
PostGIS 3.5

Supported QGIS version

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

New profile

Additional context

No response

Metadata

Metadata

Assignees

Labels

BugEither a bug report, or a bug fix. Let's hope for the latter!PostGIS data providerRegressionSomething which used to work, but doesn't anymore

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions