public inbox for pgsql-odbc@postgresql.org  

help / color / mirror / Atom feed

From: Igor Korot <ikorot01@gmail.com>
To: Dave Cramer <davecramer@gmail.com>
Cc: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Subject: Re: Included fields should not be a part of SQLPrimaryKey()
Date: Sun, 29 Mar 2026 19:20:59 -0500
Message-ID: <CA+FnnTyRcGw6jgzchW7gmKOfXdQaTTP55YnyFpyKRvEyGHVkgQ@mail.gmail.com> (raw)
In-Reply-To: <CA+FnnTzGwOiVN1CiRUtQr-joCJJhC7XtZ-4XUSk_MV+ZbcH+Rw@mail.gmail.com>
References: <CA+FnnTy+Q9D9yrB+_qWP9yMweYxJe35LwWmp1eZAEviK9Uwpdg@mail.gmail.com>
	<CADK3HHJVyRMc0Tfbd2Z8SuM6q0R0t125AiV5g=+iHejgkWrL4Q@mail.gmail.com>
	<CA+FnnTzGwOiVN1CiRUtQr-joCJJhC7XtZ-4XUSk_MV+ZbcH+Rw@mail.gmail.com>

Dave,

On Sun, Mar 29, 2026 at 10:34 AM Igor Korot <ikorot01@gmail.com> wrote:
>
> Hi, Dave,
>
>
> On Sun, Mar 29, 2026 at 4:41 AM Dave Cramer <davecramer@gmail.com> wrote:
>>
>> Hi Igor,
>>
>> Are you saying that the rest of the columns in the table should not be returned ?
>
>
> If I have PRIMARY KEY with INCLUDED clause, only PK fields should be returned.
>
>
>>
>> What version of the ODBC driver are you using?
>
>
> On Windows I’m using the latest driver.
> On Linux slightly older.

Linux version below:

igor@WaylandGnome ~/dbhandler/Debug $ emerge -pv psqlodbc
 * Last emerge --sync was 2y 5d 20h 34m 44s ago.

These are the packages that would be merged, in order:

Calculating dependencies... done!
Dependency resolution took 43.43 s (backtrack: 0/20).

[ebuild   R    ] dev-db/psqlodbc-11.01.0000::gentoo  USE="ssl -doc
-iodbc -threads" 0 KiB

Total: 1 package (1 reinstall), Size of downloads: 0 KiB
igor@WaylandGnome ~/dbhandler/Debug $

Thank you.

>
> Thank you.
>
>>
>> Dave Cramer
>>
>>
>> On Sat, 28 Mar 2026 at 23:17, Igor Korot <ikorot01@gmail.com> wrote:
>>>
>>> Hi, list,
>>>
>>> In my experience with PostgreSQL on either Linux or Windows
>>> the included fields are returned as part of the call to SQLPrimaryKey.
>>>
>>> I already sent an E-mail to this list about it but seeing that there is
>>> no response, I am trying again.
>>>
>>> Thank you.
>>>
>>>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-odbc@postgresql.org
  Cc: ikorot01@gmail.com, davecramer@gmail.com
  Subject: Re: Included fields should not be a part of SQLPrimaryKey()
  In-Reply-To: <CA+FnnTyRcGw6jgzchW7gmKOfXdQaTTP55YnyFpyKRvEyGHVkgQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox