For all involved and interested: The issue with ODBC driver has been fixed and will be part of the next release.
Ref: https://github.com/postgresql-interfaces/psqlodbc/issues/170. Thank you. On Mon, Mar 16, 2026 at 6:11 PM Igor Korot <[email protected]> wrote: > > Adrian,, > > On Mon, Mar 16, 2026 at 5:44 PM Adrian Klaver <[email protected]> > wrote: > > > > On 3/16/26 4:38 PM, Igor Korot wrote: > > > Adrian, > > > > > > Most important - do you agree that those fields should not be in this > > > recordset? > > > > I don't see anything here: > > > > https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlprimarykeys-function?view=sql-server-ver17 > > > > that says they should be returned. Though the above also says: > > > > " Additional columns beyond column 6 (PK_NAME) can be defined by the > > driver." > > > > That is not the case here, where additional rows are used. However it > > does allow for more information to be supplied. > > > > My purely un-expert analysis is, no the extra rows should not be there. > > Thx for confirming. > > I already forwarded the email with the query results over to ODBC list. > > Hopefully someone can come back soon. > > Are you reading that list as well? If not I will update this thread > with the results. > > Thank you. > > > > > > > > > Thank you. > > > > -- > > Adrian Klaver > > [email protected]
