DB Manager error: column adsrc doesn't exist any more in PostgreSQL 12

[KoponenJ]

When executing raster query for PostGIS error "column adef.adsrc does not exist" is generated. This is because PostgreSQL 12 doesn't have pg_attrdef.adsrc column any more (?). From version 8 documentation:
"The adsrc field is historical, and is best not used, because it does not track outside changes that might affect the representation of the default value. Reverse-compiling the adbin field (with pg_get_expr for example) is a better way to display the default value."
From version 12 release notes: "Remove obsolete pg_attrdef.adsrc column (Peter Eisentraut)."

[NyakudyaA]

I have also seen this by just clicking on a vector layer .
column adef.adsrc does not exist LINE 8: adef.adsrc AS default_value, ^

I do not think this is a QGIS issue because the logs from PostgreSQL are showing me the following

There has been various issues linked to it in postgresql
https://www.devexpress.com/Support/Center/Question/Details/T818996/column-d-adsrc-does-not-exist-postgresql-12
docker-library/postgres#616

[blackgis]

Any solutions to that issue? I just transfaired all from postgres 11 to postgres 12 and facing now the issue that qgis can handle this from the browser tab but not from the db manager. Any solutions on how to fix it on the postgres side or does it need a fix in QGIS?

[ra-mcinnes]

I'm also having the same issue. The rasters seem to be correct in the DB but QGIS views them as tables rather than a raster. Additionally QGIS doesnt recognize all of the columns in the Postgres raster tables. Genuinely have no idea what the work around would be here.

[pcav]

A pretty serious issue. The DB Manager is thus unusable.

[elpaso]

Fixed by #32684