search

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.63k stars 3.01k forks source link

Discover relations silently fails (with Postgres 9.4) #43505

Open m-kuhn opened 3 years ago

m-kuhn commented 3 years ago

Using the "discover relations" button doesn't discover anything with postgres 9.4. The reason for this is described below, but not so relevant any more (PG 9.4 is EOL). What is still relevant is the "silently" part, as it hides any other problems as well to discover relations (e.g. permission issues etc).

Running the SQL used for discovery directly returns

ERROR: type "regnamespace" does not exist LINE 13: (SELECT relnamespace::regnamespace::text ^ SQL state: 42704 Character: 466

regnamespace was only added in postgres 9.5. Investing into postgres 9.4.

lbartoletti commented 3 years ago

Oops, my bad ( #37833 ) but Postgres 9.4 is not supported anymore :p

Are you thinking of reusing the old query (with the bug on multiple relationships that we fixed with this PR and the other one from @SebastienPeillet )?