Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7roX-005m7T-23 for pgsql-odbc@arkaria.postgresql.org; Wed, 01 Apr 2026 09:24:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7roU-00GIQC-2v for pgsql-odbc@arkaria.postgresql.org; Wed, 01 Apr 2026 09:24:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7roU-00GIQ4-29 for pgsql-odbc@lists.postgresql.org; Wed, 01 Apr 2026 09:24:39 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7roR-00000002KME-3sKH for pgsql-odbc@postgresql.org; Wed, 01 Apr 2026 09:24:38 +0000 Received: by mail-ot1-x32c.google.com with SMTP id 46e09a7af769-7d7ebe11bffso5421112a34.0 for ; Wed, 01 Apr 2026 02:24:35 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775035474; cv=none; d=google.com; s=arc-20240605; b=bE9waSZrF3vAZaqqYxQ/PZiPvBhfbREC9JkqpXLFF4lYZkoBUsswMSgNDzrFMHjKyd /vLfntfx+QpOgLOANHljn+5wg/v+vjNro2ZO3syqzID2RM7PDgYKWvfZ7aMICL2ROe9z RNyNH3Wfbj4Bud9IvC/oh/V2u3fpIjVqvuB9HM/LWp/AgrR4ogbvIXiCCxST142xVajl sk1H2qzgxIaunlVs2nOTA3RN11B8in8zfJoHlmlk3G4OBrTFrHwZ9f3jyxpIgZa7Pa2/ 76GxqgBoMnjDPZLZg3np3W0k67+5V3fpaEVYi1N5R62fgBwWdH4teUrCoMfa3FsUMkFz pIxg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=Sh1o9v7Xch9V0Z9/vreS1g++d/p3mVMMQeUoUhUwXhk=; fh=VdI7Jd8ltg7BrSsHTeg5ScuZNH+RTut6dBv9iEiWGLE=; b=E0HF6b7sFhE0SrO5u/qg8FiRLFAsarTyyVTaxZ+OsYnKcXtdq6LP2TN3gC6+HtWFaA oz1CE24edHesj7LgINBfKr6d3uEvzYfZK0xggN91G1+NmdP6wVb6mNyrekRaXUvb1OOS qyNVMoce4aOIGOoLNeEpWwhZOuMDV+UoVuYoNTlfiRsjza45I7iSaBXG3AsdrnIpBKYO YfSABzueRN6NgooDhTMZFiT7QAC/wMrrSJiLurv9PKZv8EU4N3Kf89nkAvw45WYzPeMD NMAQCodzYGVFjWlNYcDDoe0qh+FHYzIe/lQLOrFrdvfUs5qaUPsskmedd0Qf8/Mdxu5k 7EuQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775035474; x=1775640274; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Sh1o9v7Xch9V0Z9/vreS1g++d/p3mVMMQeUoUhUwXhk=; b=k52cclSYa9fnhz36p1QQjG4zDxhoqdOyT7xv2/MGcHdpSK91dyMOs0WTUx6AmHE1YE PmHva2bgisz5WBHKe5h7FRHsS2+A5hdzaYfqaF8BakpsDytot7In9xdQTU1Z22v0/h/L vssdYcbUo0cDiLdfOakLth02fX3tGnP40pMl51PQw/j+buA8K0/1pwu1KbGE8HIHZkqQ FNtDPlit8/sfg1Q4OaoikIeKp5H4KboJp2S20XP1OhibJDPW3B0FPrchafMeVEq4X2sC l+C4UVP2trM8GfU8XHnxJS0yWKfgx6OyTQLfnYeJjqhHMiPkQZSMd4x9mE+0knyvk5cO Jj+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775035474; x=1775640274; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Sh1o9v7Xch9V0Z9/vreS1g++d/p3mVMMQeUoUhUwXhk=; b=hx+uRleZ9dOMZ+oCkQhv/SpDKvXwQcb4ubESxkPD4jx970YI8uEq8JrR+w59XGwJWg ItDrJfyEOUH99JvrP1Gh4Y4KRDrROiL7MnDZi8WZgV8QGoorAug/IoUd7yz1UsmEAEEb OQ/xiJzJ1uLAtBSYfh6etgrOHRCTwWJyQzgPl/7aimolw5g13Zeswrk323qefQNXx8eH 7Ls0tKYFaehJ31WMrJD9EDgknwqLI2Wkh6y1yxNORkCzei0DcjYG0PnUPMh09OJnIVrh DaOMS1azOfxp+FUeSRmRyFNuv1J1vlUNCj4SvQactLdYg/ckW08mNlY9CF7wf5HPjF7f XFKQ== X-Gm-Message-State: AOJu0Yyqn6LAXG4ZCr+2aSVlIzaBEeMuGQvChBjWvwFDVYmx8o4oG/2V 2rk7EGV2RZ3+BXpcTQ5LawNEZbLVUA8u0wCsHjqul3sehc0aW+XsPqqdNYcjx68RFgTNozfblWN JKOHEYi1R2+r2M5g3i0xVJ/ufss5fQ2I= X-Gm-Gg: ATEYQzwri0uTvyhWsEJbAfXv7yEH8QwG0etb/OqwIpgSMz0w1DCiWy1tNGI4BHNRta7 prqfLJNTepxHUHeaaGW8l5keO60KKxgTABjh57bwLD+wWeRRZYs6ABPfYK8BZuldPKOJjpJjJ64 Bn1QF2pvGrGjbUmPQpLV8NA8hhKFGmtz79BeXZwMk5n2O1B4RGIJNXsYDoNlOaS+2BjugxupDgz qpzlz/F4/2w6CEZ5fjh9qMTny6f9UR+PrVygrCLv+dW7Ak6kmQ0xK4l918aIuRgm8E30/KNiauw In+Pvg== X-Received: by 2002:a05:6820:1629:b0:67d:e8c1:35ad with SMTP id 006d021491bc7-67fabbf257emr1403747eaf.14.1775035473835; Wed, 01 Apr 2026 02:24:33 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Cramer Date: Wed, 1 Apr 2026 05:24:17 -0400 X-Gm-Features: AQROBzDogzRPn3B0A2fjcoBAvmC7xWr5VobOWzmDMTnoWXhpNMGgDp5PBLavWBY Message-ID: Subject: Re: Included fields should not be a part of SQLPrimaryKey() To: Igor Korot Cc: PostgreSQL ODBC list Content-Type: multipart/alternative; boundary="000000000000e1baad064e62a61e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e1baad064e62a61e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Igor, Best to create an issue here https://github.com/postgresql-interfaces/psqlodbc/issues Dave Cramer On Tue, 31 Mar 2026 at 20:42, Igor Korot wrote: > Ping=E2=80=A6 > > On Sun, Mar 29, 2026 at 5:20=E2=80=AFPM Igor Korot w= rote: > >> Dave, >> >> On Sun, Mar 29, 2026 at 10:34=E2=80=AFAM Igor Korot = wrote: >> > >> > Hi, Dave, >> > >> > >> > On Sun, Mar 29, 2026 at 4:41=E2=80=AFAM Dave Cramer >> wrote: >> >> >> >> Hi Igor, >> >> >> >> Are you saying that the rest of the columns in the table should not b= e >> 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=E2=80=99m 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=3D"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 wrote: >> >>> >> >>> Hi, list, >> >>> >> >>> In my experience with PostgreSQL on either Linux or Windows >> >>> the included fields are returned as part of the call to SQLPrimaryKe= y. >> >>> >> >>> I already sent an E-mail to this list about it but seeing that there >> is >> >>> no response, I am trying again. >> >>> >> >>> Thank you. >> >>> >> >>> >> > --000000000000e1baad064e62a61e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Igor,

Best to create= an issue here=C2=A0https://github.com/postgresql-interfaces/psqlodbc/issues<= /div>
Dave Cramer


On Tue, 31 Ma= r 2026 at 20:42, Igor Korot <ikoro= t01@gmail.com> wrote:
Ping=E2=80=A6

On Sun, Mar 29, 2026 at 5:= 20=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wrote:
Dave,

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

Linux version below:

igor@WaylandGnome ~/dbhandler/Debug $ emerge -pv psqlodbc
=C2=A0* 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=C2=A0 =C2=A0R=C2=A0 =C2=A0 ] dev-db/psqlodbc-11.01.0000::gentoo=C2= =A0 USE=3D"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 SQLPri= maryKey.
>>>
>>> I already sent an E-mail to this list about it but seeing that= there is
>>> no response, I am trying again.
>>>
>>> Thank you.
>>>
>>>
--000000000000e1baad064e62a61e--