Message-ID: <gh-postgresql-interfaces-psqlodbc-124@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Tue, 10 Jun 2025 13:09:35 +0000
Subject: [postgresql-interfaces/psqlodbc] PR #124: fix PGAPI_SpecialColumns to the best rowid
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Id: 406518
X-GitHub-Author-Login: davecramer
X-GitHub-Issue: 124
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-State: merged
X-GitHub-Type: pull_request
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/pull/124
Content-Type: text/plain; charset=utf-8

Previously PGAPI_SpecialColumns would return all of the unique keys.
Now check for a primary key first and then if we can't find a primary key then check for a unique key