I've encountered into a connection issue between PostgreSQL 15 and Navicat 15.
My environment is:
How to produce:
Expected:
Should be able to open the connection.
Actual:
It says the following message on an error dialog.
ERROR: column "datlastsysoid" does not exist
LINE 1: SELECT DISTINCT datlastsysoid FROM pg_database
Postgres 15 removed datlastsysoid field from pg_database table, so any version prior to Navicat 15.0.29 or 16.1 will raise this error while looking for this deprecated field.
To fix this, either upgrade to the latest Navicat 15.0.29 or 16.1 and up (might require new license), or do this:
Enjoy!