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 1wBGr8-000tkg-0l for pgsql-odbc@arkaria.postgresql.org; Fri, 10 Apr 2026 18:45:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wBGr6-00EEy2-0y for pgsql-odbc@arkaria.postgresql.org; Fri, 10 Apr 2026 18:45:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wBGr5-00EExt-36 for pgsql-odbc@lists.postgresql.org; Fri, 10 Apr 2026 18:45:24 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wBGr4-00000000NXD-2lUz for pgsql-odbc@postgresql.org; Fri, 10 Apr 2026 18:45:24 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-79a46ebe2beso24845577b3.2 for ; Fri, 10 Apr 2026 11:45:22 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775846722; cv=none; d=google.com; s=arc-20240605; b=FLJw4N/SWMwo8/UzEJKg3JwV/KXVMSuf7tJyITPxqWtq7cG+86gi4v1s9ZRKdRuRQ8 1GJ8DyksdTeum/3tR7y/FTqU69XeYZyGTv/+ZQxWLJrvH+7w8Lb067PlRPJeO2wvFHdV foD+zIgkWD4449iLMJAHJNiap9laeCQ0U9ZeJF8X4E1O98KesoAMpvhS9b23HUfUGGdj JvyOMidmkUyQgPg7ti934GHy04Lb4IfJRqyPoUqSRNE7J2FuTy1KfjYVfhheB/XSDiix Ybhv7SkpVXnJdu3zd2Xy0CgB9nFdE8QRdtfTm+OvJYy+zf+BYLMzYiXuCuBmXUbsaGuB 3j7Q== 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=k8CspLQG2N0fEAQ5/WVw8NSQrZaOiYd0eXceQWWJpKA=; fh=gQ1ypmDyWf3nH1gznU9Ug0JOCBZ+shqszu66x8185Qc=; b=IdeT8a/ifOAILJGnhQxP6y8iHB0RerNHwqV09MPDAaA4oVZPpHC3DQWa3eI/uckvha nIJd8lo9ZgRDzRtvg3VhUq+vuHx9EcMbjF489CD9xNSUlBotY090I0kiQiMx/YwgBKv6 Tx76A0Cs2EsAq+roe/KtLqnN4GHoncKhcAybyGZa2CLZbTXO1DsaaWIN3kCtU9QRSGVU zckL2wiZC8hh023+Bit/wAAgCp5ZrzkyL+38SbqUBwJpQK1urdSVeH4S35x46FEkxe2S ndBXAd/Zd+L4m5gZ34bhWNJlLbERZvGjRdzqNnkYkzPGg5Sf5f8u9mxTqOEZNYYMKjYr lprw==; 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=1775846722; x=1776451522; 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=k8CspLQG2N0fEAQ5/WVw8NSQrZaOiYd0eXceQWWJpKA=; b=OSAYJaGPm0oOcZCL5QFYHOkSEyfqjy6VObZ3I8vuiVeqj2JFgFIzoG8d6xkPzX2eff pNvWMqFYoho+7myRUfsPo4B6Vxad9GVIC7Rb2vYbogSpYH3cxV5sN5m0+hWnEWkX27Na BRJUa1fvfmcDDIVnk4tViogdyqW/IBUk2OZK/JpFZIHCw7fFHgOuD/xpiOL3kQUjprsV 2RdbqipYJ9N7twmSufrOZpBrtGbGnLcNkLcjzYFW5QDycC98JFvjW1+OQ/jc0R2mBR6d 7gz8GpZXMbjvr1eqThLFthwBkKi1AaKfnS84iucvLvjeUj/a4Trl/0lxbBh8cySeMd/t WGLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775846722; x=1776451522; 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=k8CspLQG2N0fEAQ5/WVw8NSQrZaOiYd0eXceQWWJpKA=; b=OGCeXAcp1kp/0ZlCaXMIS5SQzmSSA6/lfEjcLepciN0PI94+E7mnAo4gVYi/jzvCo1 2By77cd8Hf50GhjGChleZVFy+HWlzrNgn9Kb7mYch68yOfP2AZZQNlUOsIYGcru3Z9nV 0Ae7CIG0MY2fTZJzt+wACiqa8SxEOruRRe3gOs4fa9qOKRkgQ1VdTvMKgBR3qm/vWayR jQX+ImBB2yW3TSnnHACA6bjV4B9Z94S5wBEspJ8UGNLZ5K1zI9ThqDC2gnvT3EOv1PRA 9TzypAVX8JsqiUttEfwCmGGJRYnDVsKLtK2EVZEstu6OBKUZ/+SSgue+XI+ij2CGxdYG lpZg== X-Gm-Message-State: AOJu0Yy+Xn5/O0AeutvL0CD7l/MUZbVHglHaLk0YC/MK0p5v7CK5iQu0 HwaJvE4bW/rT/Sryu5K+CLxJXahjuqoCHeD1W+NZK9INGBjwEclnz4MM1pmH4Dax9V7tbMKOU9Y abeGceRTzYh1PbzK1m6ibDGOrNpJxRiw= X-Gm-Gg: AeBDieu4NJ2IlGlUioljOa70owoSwCLp0+NRHpHaYn3FYRbhy4AsozSVgP08jqa+Iur co1p+qbFoj+v1ni32hjI0bbEC7kJ2Q7EVwsKwAi+zdvBs464VG4cODIqYl1YY9uYe9N+K1NPwGL jFIPVr0zioXlJ9RGPMbXdrSLE4SPebMXwMzrz+VGP/zunsEIvrUhaYW+MakpNzKtsUUlZCpm365 uLOyUEjn1xEU9vM3FOJVQiq7RqE8vXxBzqzBd14y2gm69x8toDh8C9Hslem9Un+PxWmEx0YG+jU bH3Jm3ygICaGAUJ1BdG9shrJ2hcqa+INtgK2RbDStmWwN16tUJ7CaW3BxMlr0UdehUgOeD6M X-Received: by 2002:a05:690c:9:b0:79b:deb2:f5d3 with SMTP id 00721157ae682-7af6ee46ba1mr45161197b3.7.1775846722102; Fri, 10 Apr 2026 11:45:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Igor Korot Date: Fri, 10 Apr 2026 11:45:11 -0700 X-Gm-Features: AQROBzCkzImBSr9ugSqrH4qPsst9g0l6bnL-sexcRCSYmcIBNQkhxwH8xHqmKA4 Message-ID: Subject: Re: Included fields should not be a part of SQLPrimaryKey() To: Dave Cramer Cc: PostgreSQL ODBC list Content-Type: multipart/alternative; boundary="0000000000000bea69064f1f894e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000bea69064f1f894e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Ping. Did anybody look into this? Thank you. On Thu, Apr 2, 2026 at 6:06=E2=80=AFPM Igor Korot wrot= e: > Dave, > > On Wed, Apr 1, 2026 at 2:24=E2=80=AFAM Dave Cramer = wrote: > > > > Hi Igor, > > > > Best to create an issue here > https://github.com/postgresql-interfaces/psqlodbc/issues > > Done - https://github.com/postgresql-interfaces/psqlodbc/issues/170. > > Thank you. > > > 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 wrote: > >>> > >>> 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 no= t > be returned ? > >>> > > >>> > > >>> > If I have PRIMARY KEY with INCLUDED clause, only PK fields should b= e > 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 > 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. > >>> >>> > >>> >>> > --0000000000000bea69064f1f894e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Ping.

= Did anybody look into this?

Thank you.


On Thu= , Apr 2, 2026 at 6:06=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wrote:
Dave,

On Wed, Apr 1, 2026 at 2:24=E2=80=AFAM Dave Cramer <davecramer@gmail.com> wrote: >
> Hi Igor,
>
> Best to create an issue here https://gi= thub.com/postgresql-interfaces/psqlodbc/issues

Done - https://github.com/postgresql-int= erfaces/psqlodbc/issues/170.

Thank you.

> Dave Cramer
>
>
> On Tue, 31 Mar 2026 at 20:42, Igor Korot <ikorot01@gmail.com> wrote:
>>
>> Ping=E2=80=A6
>>
>> On Sun, Mar 29, 2026 at 5:20=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wro= te:
>>>
>>> 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 <<= a href=3D"mailto:davecramer@gmail.com" target=3D"_blank">davecramer@gmail.c= om> wrote:
>>> >>
>>> >> Hi Igor,
>>> >>
>>> >> Are you saying that the rest of the columns in the ta= ble should not be returned ?
>>> >
>>> >
>>> > If I have PRIMARY KEY with INCLUDED clause, only PK field= s 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
>>>=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.000= 0::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 c= all to SQLPrimaryKey.
>>> >>>
>>> >>> I already sent an E-mail to this list about it bu= t seeing that there is
>>> >>> no response, I am trying again.
>>> >>>
>>> >>> Thank you.
>>> >>>
>>> >>>
--0000000000000bea69064f1f894e--