Message-ID: <gh-postgresql-interfaces-psqlodbc-180@github.com>
From: "Blacksmoke16 (@Blacksmoke16)" <noreply+Blacksmoke16@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Sun, 03 May 2026 14:30:13 +0000
Subject: [postgresql-interfaces/psqlodbc] issue #180: Incorrectly reported DB version
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Id: 12136995
X-GitHub-Author-Login: Blacksmoke16
X-GitHub-Issue: 180
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-State: closed
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/180
Content-Type: text/plain; charset=utf-8

I noticed when using a Postgres version >= 10, the reported version from `SQL_DBMS_VER` is incorrect. E.g. the latest PG version `18.3` is reported at `18.0.3` instead of `18.3.0`

Probably related to the [versioning](https://www.postgresql.org/support/versioning/) changes in PG 10:

<img width="1848" height="142" alt="Image" src="https://github.com/user-attachments/assets/5dc80e9b-2679-49b3-b8eb-8de421c0d7b4" />