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 1w2IYK-000ANd-19 for pgsql-general@arkaria.postgresql.org; Tue, 17 Mar 2026 00:44:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2IYI-00Ed2I-0B for pgsql-general@arkaria.postgresql.org; Tue, 17 Mar 2026 00:44:54 +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 1w2IYG-00Ed1q-2t for pgsql-general@lists.postgresql.org; Tue, 17 Mar 2026 00:44:53 +0000 Received: from fout-a3-smtp.messagingengine.com ([103.168.172.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w2IYD-00000000WEn-0jsI for pgsql-general@postgresql.org; Tue, 17 Mar 2026 00:44:52 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.phl.internal (Postfix) with ESMTP id AA98EEC00A9; Mon, 16 Mar 2026 20:44:46 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Mon, 16 Mar 2026 20:44:46 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1773708286; x=1773794686; bh=JL+wUSGJlgBP//wX1bLDx0gomYnBNqfN12nJnYJnuCs=; b= IZVXX7DV8UxlKDNwiwLpLMkA4GJmvbqfVrLEjhkrosLZ7teJWIEVaASzNpmmUiMO wh8AodZ7E4D+Y0xV6fA83tf14gEVmW93T0dTmcdYYjHuJ4sH7PWNzBeK7ugDyfvW X3oyRvXQdMbdKcgR0CSxW4iP7hRs0IApeHmhOWGwAF7TInRS3Un5OVSICVTPJUyr zuiBbUffFlF8qUPz/Bf7bEsrjtNliCGcyOhy0waHyTbl9iPod+8BhWxLETvLXdNh rgopVWXyk/YYFJ6QSb8LgmP1MrLr4li4DseNZNn2dspN0jtOD0u5kRC93FO9cbuR Kr9o+GPLPuo35P+qD+OIzg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1773708286; x= 1773794686; bh=JL+wUSGJlgBP//wX1bLDx0gomYnBNqfN12nJnYJnuCs=; b=0 e0TDVrOav1mjHLQDj2jcg8GJxSPyQvqbXVW18vpLscJqD8qAIZyYugpRaPrPhd7i xvrGzUH6PH+aQ90B9vaV3eoSwV44jfIEnxgAY/m+fEUwuqVAes/vLKSInWg/5ntq wMh2GOG7tNGA3b2cG5a9ddX2/aJxnIFTOwxKjUBNRoaHFvPeaWRf806VdfToJa/W tmtoTuBoum0mtSev9uzFaiU/RibGa5Q0vnqd/9iQQp8KlMh0XRLurgFou+/UoH7Y 2OYfwr4HajhYR4+VDibFXvLkw84PQFyKMwizrw7N0H1AEJRNwpTNfDSG2LsS+1Qu 1gxvFeQiPvDBmviTVx4eA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvleelkeehucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgr nhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh eqnecuggftrfgrthhtvghrnhepgfetvdeilefgieetfedufeethfekvdeuffffkeevieei vefhheduvdfhiefgjefgnecuffhomhgrihhnpehmihgtrhhoshhofhhtrdgtohhmnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghn rdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhoug gvpehsmhhtphhouhhtpdhrtghpthhtohepihhkohhrohhttddusehgmhgrihhlrdgtohhm pdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlhesphhoshhtghhrvghsqhhlrdhorh hg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 16 Mar 2026 20:44:46 -0400 (EDT) Message-ID: Date: Mon, 16 Mar 2026 17:44:45 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Does included columns part of the PK To: Igor Korot Cc: pgsql-general 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> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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/sqlprimarykeys-function?view=sql-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. > > Thank you. -- Adrian Klaver adrian.klaver@aklaver.com