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 1wBUBH-0016i0-08 for pgsql-odbc@arkaria.postgresql.org; Sat, 11 Apr 2026 08:59:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wBUBE-00GDSE-0g for pgsql-odbc@arkaria.postgresql.org; Sat, 11 Apr 2026 08:59:05 +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 1wBUBD-00GDS6-2u for pgsql-odbc@lists.postgresql.org; Sat, 11 Apr 2026 08:59:04 +0000 Received: from mail-ot1-x335.google.com ([2607:f8b0:4864:20::335]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wBUB7-00000000Ubl-1ULU for pgsql-odbc@postgresql.org; Sat, 11 Apr 2026 08:58:59 +0000 Received: by mail-ot1-x335.google.com with SMTP id 46e09a7af769-7d7f92bde91so1825207a34.1 for ; Sat, 11 Apr 2026 01:58:56 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775897935; cv=none; d=google.com; s=arc-20240605; b=Sz6k59raQeRDEtuD2QW2aAEN1JjG4VIaPDXtZ0l5EbWkjeq1HxR+8quDfGdYQ7HJs9 qQqdhDn6ESKAdScdG3IgDU/A5dqMRHaGcAjQoNSsdwk+Kinlvoz4iR1s4OfCgCh/PipV 7DQvPvVkUHIE6eMpxioMz93/ax8OYqU8NxPV1nqw9wWJraYwFgu2D2swN7k6BX5McGrE 2S4bv7w5QpGX/75mlTa+XLTIxjKeaHcyGX4KxOKXEcq8EJAxRB8Rqwt5C2wK8VHLKEOt fNMQSnPSfj7hC9cC7O4HG/Q0bURBB+z6vOEOzJ9bqHY9NyrzgDLzUgU2E/NaF8DvtKDr 6jYg== 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=mcdkvz1Zpse8l1w3kjvWhcXoErZByJ2ECjqUPu09U+A=; fh=VdI7Jd8ltg7BrSsHTeg5ScuZNH+RTut6dBv9iEiWGLE=; b=T3OIeVHCk3NUUDmsRAydfXtTgNG5YV3V6nqA4J/0id3g6EWL2NOCqnqrfLzt60CQ+M vy2XlpAQXEEHanKIvGuapKTj4UIHhwqLpKWygTHXOaqsR/7QWaa7mH7pqik19/EgDxGQ +HVLfiMRRk6t+vtqUV/r0+6Hcnj+xFTbkvQxxYNCybn7T0lHumrPRoM5AEiO5OC5H7Em dkNNf3lhFpCQwXOhFwk8p8jo0rYxHFTEh5kxUiJ1rD8BYcyKOqQYhhcoyc00a25CR50k xknpTKPkklEW0++PUNi3CwHV9/N+RGKyJPGIHhu8fHgs6IIleWTOiRD5D743ag0JXmR4 kntg==; 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=1775897935; x=1776502735; 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=mcdkvz1Zpse8l1w3kjvWhcXoErZByJ2ECjqUPu09U+A=; b=hlmnwT40ciAMZ0CtT+eruyBvApXRQH+1W7C2sApCrB3JmdeFspXxtJ6F7SP+MZSLYD rqEAB8EfK2APijCImmuUpKM0ltELLR3jIl8jFVh+pRy77SzbS24HO1qijGIlWyyF0FEK 6tmoSzAAdrHWQOXVLuBjmjnddkMe8Baom4AmZ9tXwf8ztFjEl5DyD94L6xkOL11R85xU s1rpjJJpqoHzuo0kpChhBsa1ViiWLvehRbAHYGrKenL/b485dxelYm+prD6PMYZiF5XE gXkmfQnSGedaIr3v4ITILwJwLhROkNdt+9rp3ae5tqpdhvYxYX1Vf9OCRME6s2+hGeV1 Q+7w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775897935; x=1776502735; 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=mcdkvz1Zpse8l1w3kjvWhcXoErZByJ2ECjqUPu09U+A=; b=rxrejvlGg6SDDw8O4COA/JI2/zYmkMqbqbzmrTaJqgtE5G7ebisfv8glbxMzHJd1eF Ls35ZCH3XvYEXpFf9xfNRU5s8PkOAODE5Vgb9viFHG83GVGDcg/t8mF32zWXpYVrtNSB yLxYASIu26/OJna0RQ7WSF0K5QjJ+woENFU8EsDzl+Onvgqm/42n19l9R5V2hxYSbrr3 xmA4mj9ykVPJTQnU8DX094vVDKjcR3swsnHyF/DPh5M7m8wED0XU9/AS9W9VQvXADPmk dTIgdhE3K63aEyncNfBeLapCXUAlEICzUY+dSORaBRXIlB1tkPDxTUk2uuumRQBugcEr Er/A== X-Gm-Message-State: AOJu0YzDqyu83JRdjJarWpRMZnOgTid8duoo5ZiA/MnViWfciQKWBe0b qyU+8B7zJrPEGT4nE5hhzfpGvWSGmUCqqmydbitEwVHJyZ+CAQxaIcXL2W4OiN/J7KsXEBHyex+ 2a/RC6miBtlxbiPGHDZCb+eDm0R0aNe4= X-Gm-Gg: AeBDietkLUxZt9t6o4vHcCCzxpfIdI++CScintQ7WlzVFcQV5R8Qk5rPisr5Bjuj8iy QID9gMiRp8Kia38mopzawiWRi2zfniPhwbxeYUHFAsPX2ceA4ZMdHo9jk2kvR+j+d1CCaMfomVW 5NEKzozWe8fBfHqk4WgDqXt+j6OrfZF3oQwKroYZ5hyi3GjbRkjU14tE8lvvAxU7q4/xceuJDuv jFnFReVycFgeIgpnaGuStnlUEcuHJxEtbzi2hpY6nYtauBALgNPrvEYryvhBQTEALAgaDojWZTO aPdSQQ== X-Received: by 2002:a05:6820:198b:b0:68c:3d8e:7911 with SMTP id 006d021491bc7-68c3d8e7aeamr2837442eaf.44.1775897935150; Sat, 11 Apr 2026 01:58:55 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Cramer Date: Sat, 11 Apr 2026 04:58:49 -0400 X-Gm-Features: AQROBzDIlANbVfP2ZLSXdUxsMzKToihPVFq8L0d-veI_qhL2dchh2JMZiPeWtuY 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="0000000000009504b4064f2b7572" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009504b4064f2b7572 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I haven't had a chance. I'll see what I can do this week Dave Cramer On Fri, 10 Apr 2026 at 14:45, Igor Korot wrote: > Ping. > > Did anybody look into this? > > Thank you. > > > On Thu, Apr 2, 2026 at 6:06=E2=80=AFPM Igor Korot wr= ote: > >> 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 >> 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=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. >> >>> >>> >> >>> >>> >> > --0000000000009504b4064f2b7572 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I haven't had a chance.
I'll see wh= at I can do this week

Dave Cramer

On Fri, 10 Apr 2026 at 14:45, Igor Korot <ikorot01@gmail.com> wrote:
=
Ping.

Did anybody look into thi= s?

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.
>>> >>>
>>> >>>
--0000000000009504b4064f2b7572--