NikolayS / postgres_dba

The missing set of useful tools for Postgres DBAs and all engineers
BSD 3-Clause "New" or "Revised" License
1.03k stars 113 forks source link

e1: highlight outdated extension versions (fix logic) #32

Closed NikolayS closed 5 years ago

NikolayS commented 5 years ago

It is incorrect to compare installed_version with pg_extension.extversion, it should be compared with pg_available_extensions.default_version. It lead to incorrectly working actuality flag – at all times it was empty.

This commit fixes it. Also, available_extension column is removed – its logic was wrong from the very beginning.

Example: