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 1wF3k1-004hpk-23 for pgsql-general@arkaria.postgresql.org; Tue, 21 Apr 2026 05:33:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wF3k0-006Cbu-2k for pgsql-general@arkaria.postgresql.org; Tue, 21 Apr 2026 05:33:44 +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 1wF3k0-006CbO-1i for pgsql-general@lists.postgresql.org; Tue, 21 Apr 2026 05:33:44 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wF3jy-00000002FLo-0XLo for pgsql-general@postgresql.org; Tue, 21 Apr 2026 05:33:44 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-79db5e18ac6so48828047b3.1 for ; Mon, 20 Apr 2026 22:33:42 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776749620; cv=none; d=google.com; s=arc-20240605; b=J6fpVt7OZjRNn9RkICXGT8Z24PyI/ZPoru7wQKtcni/zVY9PP4+U6Jd7BIwPnCQ599 m9qu6dV9L8i0V+cVQjZNbWjIDmXhLJ7St9bt9i3Z6n9JPf/m+FC65+NE58G1huy8xGED 0eAapfcma7uOsKpDQgJJnvzCJ298/O/O8eh6E9G7bk8kjifgGmd3oIMoCBrCdEaBa6ec NUgXqU7/dI/DfbzI+Zi8w50ZD2/UR2EO9/WhkV2WnT0V5M9J792fzcjVk9iscHDL4X+S gyq46/T7JhS02gHnNZwBLraGz5XKA03rZ6HQSguB333LKy0+gcw4KtAiW/kk906NTpwU 8FyQ== 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=T3k8edG8g0qiwyjq+BuVLFkSTh6CmJ0SRGNYfdhnzi4=; fh=cQaUnmuwjuR9OsxDL7SxCVBwEjDYlbKL9Ym3U6WPyC4=; b=QwTmENZ5iOD65BAmIi7SudA6M4zNa/i7/VyeDvljiA+vqEHmq3fYIHiMmdq6CuWGf7 NG4rzubWENslczen1NovKjC6HYQ5jxcu76QEnwslCe10us0a4o75+2dCpy1LwEGIDWn7 EmZCCjF74pPNhPIRBqs9jSK9OKG4QbA5IphJfjO/ENFyXZSfh/fipCIi6eaqSa1ifZ4C Ad2UeoMI7BE2tCdHfImUpKZggDRnjtlcIEd22beYzhASRroKwH18RGaaRp5Rzb7eUJT3 t/5IH07AbRYRtnwLkOKFl4yT3K8zDezt8WQGwNjDZm55yATXmz3Ui7f923SGbZyJGq5u NXyA==; 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=1776749620; x=1777354420; 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=T3k8edG8g0qiwyjq+BuVLFkSTh6CmJ0SRGNYfdhnzi4=; b=hfl83PrIZolRFCLwSVyZy1d/7Q5mNLRrndx+xM0xecCmn3aoPkdQbRl4ByPA5RCfr3 kIZzEsi/yTvxGNraxPr/EJVfYo7DAHwZGpiM3W5NYPdcMhkRt9B6QCahJw8V3QtfRmJ8 8H/7oW+m5ya2+VfT/dwO0daJTXvouT6XJ6OCt9Bxy3Xa3EI6lcwwJHfnViNZSK84BU+x U9dmOvVizTDxbxxD+AjBdA+FKz8u+39MHo46byqvV2JwT3/DuJLsQu/3NuffgZeLGWXd ShODFxlyj2cl5vPd6rSzBITucqOHGjM3mfaM9GU0wrdAwEnPBdRTjwYMazUz8RWK7zVe 6G4g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776749620; x=1777354420; 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=T3k8edG8g0qiwyjq+BuVLFkSTh6CmJ0SRGNYfdhnzi4=; b=p0AJtMKc5HT4541yl1D4dlhe3UypIfbqolh/h4LjNri5JXviKHEa4Ph6kIIlw4husA 9jHRdAm1/wXU6Ts804xP36iwAj7x0GGAwX/TYq7v3ET5Q3tfQhm7aZKGBUQdaDCaTOvo PQqCNXf417TZaGpKW8vFXowrEeByYxoRBBRTe1dZG8DRmRdLdDDHuLXW6XiXU9uVrE9n ChP9QQXdb74DdeTdQr0vJZwIVFoZRASLbl2yP2UB9oCcwmXln62hoTGbaYeD+Ar1WPGq S0mjsnPDXF2slwasc0RvKXXueXeAE4vfKd0yyhPjFgCO6DMAFNZS9AD9ePGMqxjuXEeu hS2g== X-Gm-Message-State: AOJu0YzsXKNMtLsUH119pd9fYUXNdzvLvupf/P5vRu/+TbZKmZLU6WFa DZGoYTrDgIN36hDAr1ZStbRpkDdhmMKNcx0q5cVnf4RDqh3QfFxFyW1tLhkKoJoFYnS5FNgDXHs bti20ixMm9qqunu2D5gcw6h2s4JfQhgKQcDMt X-Gm-Gg: AeBDies/8zLkv/B9tAKeP2eMcPS+NBqG+fihhFqT0b1sd0xyWIUu0afEMPrBgfUy/v9 MS25aiW/HHmKWSinRmxbGtxDQok+VWsNiSZdVz0l+qDPVHoZjBawI/DVmUp+17ZuewMWn87VcJO luh3ASDoB5zbjY0cMS6sNjs60UZTfZ1cec664NDmbLDjMbfKYE1bDL+OxHWnJzuHQxrpsjEwiZS VGeBc8z39APZFhx7MohVTiUyxc3BD4Ly1tcfX0Tut8WLvBccugDJRWnasc/cJV7DMmG660D4tox bOKf/NvaCa/9ys6Q7vDE+wadbiWX1iFIb9s3mvXsWgZpaiw4RgXpH/BNfcgkBQeWs+Ur7y6ihUV 6IO7aSQ== X-Received: by 2002:a05:690c:ed5:b0:7a2:80a9:93b9 with SMTP id 00721157ae682-7b9ed417f81mr113535087b3.25.1776749620311; Mon, 20 Apr 2026 22:33:40 -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, 20 Apr 2026 22:33:33 -0700 X-Gm-Features: AQROBzDtlzj_4UoQRVRaa5S3XORt3uH5KY1J6TjDlZeGy_GNl34M5OTWDZLVSCs 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 For all involved and interested: The issue with ODBC driver has been fixed and will be part of the next release. Ref: https://github.com/postgresql-interfaces/psqlodbc/issues/170. Thank you. On Mon, Mar 16, 2026 at 6:11=E2=80=AFPM Igor Korot wro= te: > > 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/sqlprimaryk= eys-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