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 1w2IyA-000ApM-2L for pgsql-general@arkaria.postgresql.org; Tue, 17 Mar 2026 01:11:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2Iy9-00EjUO-1r for pgsql-general@arkaria.postgresql.org; Tue, 17 Mar 2026 01:11:37 +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 1w2Iy9-00EjUG-0o for pgsql-general@lists.postgresql.org; Tue, 17 Mar 2026 01:11:37 +0000 Received: from mail-yw1-x1132.google.com ([2607:f8b0:4864:20::1132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2Iy6-00000000WQ6-1IXe for pgsql-general@postgresql.org; Tue, 17 Mar 2026 01:11:36 +0000 Received: by mail-yw1-x1132.google.com with SMTP id 00721157ae682-79495b1aaa7so47845617b3.1 for ; Mon, 16 Mar 2026 18:11:33 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773709892; cv=none; d=google.com; s=arc-20240605; b=lD8Wwy/lt/T4cJEMjuIifa5313riuSb2+1AV+Xu32vPFBnOkSfxKKMfKB+DgFk1rXE xypWytLy1cjGTMDjDhYu+zQ8AT6YNDvhXTV/HPLg1GLr9MV4PskIoAbx1H9to//5aH9k c+pC4V/hd0n4uCVbh/dBtYoI9pxxLbTgSC9DthZT9lbPT/pYOH+GF9ins4mvP3YkP9dk adEaFdgd6o7lvGCruAtd8Vpv0TuNN/dnvfQ2mvnran0N2py9mBKTa1yLok5TxGCsa3YU 5aYKoZH5BkF2U/5ZtjHutnw6RP1dsp6JjskTB4WB/IN+5kffXJuNDC6An1sjZqvcJ0ed 0X4g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=q1P281pGH+0vgju9azUyTyJDNp4QDhwEMN+1GA/P8mw=; fh=cQaUnmuwjuR9OsxDL7SxCVBwEjDYlbKL9Ym3U6WPyC4=; b=WvCqJqvIb3/fO7/mHvH8Mxx2RgfJjKKCRyQt95QXpTh+MX1jkJSJLV8cmxeJt/8vp9 sGlo/zqdVWv61QuDTFa9+hOWxAgwnT3A7b8QmlQUTzVB+Ub+KFb0qLa7PoKG9izj09tL rklWKxRO7pTPBOX5KIoEmcp/ay+CKoCbw13QUM98lrHeJe0v2RWxB9ziV+LuPZLTvcCN N0uW8aKOA+/T02oDiJ1P6piZkXn2tEzt0K5Ko7bqvNMqX3ZcwaqC4Jm60XoGhvTg6/xB dAFBoWH39kqy44DMESSSojEMHUWBUMIw6kWNRqy/wSrATts0GL1FujqjuBm313I0afim 9YPg==; 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=20230601; t=1773709892; x=1774314692; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=q1P281pGH+0vgju9azUyTyJDNp4QDhwEMN+1GA/P8mw=; b=HZWFAO9pANXpJxmIDPiNnjRxr59igQSWUUjszrPHFbvIJLc+ql92bK9TpvIpWKhsi9 S9lN+y81C+GyWvJkGg/92LHy7Uad610rWGdH6Rmt+FEcD64qE95fpC96ebdQVYt9140z WdAIhO1KV17j+PMWWdqaVAfLV9iGvwLKyQ5ETdD6Pt5hX7N8NniD2EjQgDMugsWSoTlS N+FB0pWRP7Bdgo90rwnGIyml1VopFIRzlC5ioAexnCVIhD4PGVVe+J2IkamEoszNY6g0 iu2KVlCc2H7hiizek72QwMxxD34sULI/slDDeZJ85A76vgPPEs74/U6SFzT8kXxg/FRv fc+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773709892; x=1774314692; h=content-transfer-encoding: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=q1P281pGH+0vgju9azUyTyJDNp4QDhwEMN+1GA/P8mw=; b=bS36nl82XEe9KzD6JdhJaP492exAreaQWzM4um5Shfqr/tAr/Gw51kTU+dIypgMSML Utcw2KR43YIxUBbNL36F1nXUNV2MggwhGwXvu40yuDT0zL+rb/jbEGc1qblgHgeQtf/O LitH/pMB85MCK1BK2oPsm7cHPxxVjnIk4tz8Pz7yzxIe2vgALw3R0tPQ8TQHrvtDGeju FO+fsmop8qQiPJPC+UBLj8LEVT5BIHUzITt+Dk0AgvJt9+4MXwjl9IYv4GPmh/3DHAPA USHissrm0ZLn2HHt5RdcHEXytZzTuGvXlheFVxbEXDadbEuLyf3lCEU/IOnPrOdsK4K+ 9AEg== X-Gm-Message-State: AOJu0YxP7wKa65dOaxOKGvpU3TdeWcQY6ERWrO5cOW2u+oJUCf1HXOPy irdsE/qxaotFOvo6yKB2LrZ08HNITUdSVueeAj+2pf7T+h3pcGb/852yb7ky8et0OEIvzdGiosK i8N4ROjE7SLGtfT7X6Cx4/RFoQuBgRhUtLg== X-Gm-Gg: ATEYQzw6rARq3VJQaWh/nfozvQZ94UVZTRIuJcDQyhQnqA7Fc+n46p8iTxj/50mU2m0 UEwMWXhrVgaoY+oFtMlJE/nC8urCH4W7SRhzbMj7JbRrN77u/Z9u5Q561BD/fLsz/Wsh4Vmhtlu AX8rAGii4McPNZtDTaDM/dIasSTrZRLwCl6mpau6pLDgi+WWGgFduHnGRtmSvOWxOFvZmZd5ic1 9l0UfgxOztvhjrzmrahJY77KqRhnrC9/X3JmkTrSI9Tppgdbr58HmMep7HWz6lV/u8GqQf6G/Nm cxmAvMM8osgVoBP8cnI8ZE6m9US+PG0FWw/wu6TjFb8H/U4yabhR7yi5I0XFGm2/QxiHiU5oMlM ll7uQPg== X-Received: by 2002:a05:690c:998f:b0:798:980f:6706 with SMTP id 00721157ae682-79a1c0e4895mr160785027b3.22.1773709892291; Mon, 16 Mar 2026 18:11:32 -0700 (PDT) MIME-Version: 1.0 References: <3547f40b-08b9-4d0c-bba8-f1c26d0bf09d@aklaver.com> <2c31c118-7f8a-4359-9c4f-4cabd9df4262@aklaver.com> <7461c77a-4536-4f53-b951-99b9ca33db79@aklaver.com> <105a9d1a-c219-401a-9b81-4d77dde901f5@aklaver.com> In-Reply-To: From: Igor Korot Date: Mon, 16 Mar 2026 18:11:26 -0700 X-Gm-Features: AaiRm50iUGQWCLoMAq8oNLY769y5R0-pW21mQaFvnPPGtrMPdJ5FdGmpy4tJGwA Message-ID: Subject: Re: Does included columns part of the PK To: Adrian Klaver Cc: pgsql-general Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Adrian,, On Mon, Mar 16, 2026 at 5:44=E2=80=AFPM Adrian Klaver 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/sqlprimarykey= s-function?view=3Dsql-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 > adrian.klaver@aklaver.com