Message-ID: <gh-postgresql-interfaces-psqlodbc-79@github.com>
From: "raddakal (@raddakal)" <noreply+raddakal@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Tue, 26 Nov 2024 13:25:25 +0000
Subject: [postgresql-interfaces/psqlodbc] issue #79: SQLSpecialColumns ODBC API does not return Columns part of UNIQUE INDEX on YugaByteDB
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Id: 43139294
X-GitHub-Author-Login: raddakal
X-GitHub-Issue: 79
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-State: closed
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/79
Content-Type: text/plain; charset=utf-8

Hello,

Its a very common use case where an explicit primary key is not defined on the table but instead rely on the unique index. The ODBC driver is expected to return the columns that are of the UNIQUE index when SQLSpecialColumns ODBCAPI is called.

[SQLSpecialColumns.zip](https://github.com/user-attachments/files/17919927/SQLSpecialColumns.zip)

Environment details:
--------------------

OS: 
OEL8 Linux 64bit (el8uek.x86_64)

Database: 
Yugabyte DB 
PostgreSQL
Version 11.02.0001 PostgreSQL 11.2-YB-2024.1.1.0-b0
ODBC Version 03.52.0000

Driver:
Driver Information:
psqlodbcw.so
Version 17.00.0002
ODBC Version 03.51.


I have attached SQLSpecialColumns.zip which contains the standalone ODBC program along with the detailed steps to reproduce the issue.


Our major release is blocked because of this issue. 
A quick resolution/workaround would be highly appreciated.


Thanks.