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 1vJVWX-009CpA-04 for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Nov 2025 11:29: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 1vJVWU-000lTC-0O for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Nov 2025 11:29: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 1vJVRr-000aZV-2Q for pgsql-hackers@lists.postgresql.org; Thu, 13 Nov 2025 11:25:08 +0000 Received: from fhigh-a7-smtp.messagingengine.com ([103.168.172.158]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJSdU-007V9Y-29 for pgsql-hackers@postgresql.org; Thu, 13 Nov 2025 08:24:58 +0000 Received: from phl-compute-11.internal (phl-compute-11.internal [10.202.2.51]) by mailfhigh.phl.internal (Postfix) with ESMTP id EA06A140026A; Thu, 13 Nov 2025 03:24:54 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-11.internal (MEProxy); Thu, 13 Nov 2025 03:24:54 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm2; t=1763022294; x= 1763108694; bh=fbCr1jE7Z2DvgIc+2Ok11gv0w4l1SGRAkJHGeIZsfU8=; b=f A07geP2t8sbHqazaVF1aTlD3WECSPT+BAuxRTXx6tLEIZMb8P5+jPgl5o6qrlGnn 4DbUQaoxlZzEWLBteWFWFmcuM8pQSQ7fAGROUxYvPuAZRP0kig6Ws3zirjCH/zcK aJqAZEBFfv194L5ayJEpviyBdlZHVcynyKSxn+tI5DbqoS/qWbI2Sd9L6UW+La9q Tjbl//GlRiXBPowMdoT/H2hp2cZUg6nZdfERyQJ1+sYPblhhxnIIC1TpFKlnvyDe 0nnb7f4G479QTZuhR2MtTI2EQOgPx3uOxwwP8vXc83iclK1oWdLDUxsMexouRE08 7fzI429o5HAzs0BFFqJhw== 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 :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1763022294; x=1763108694; bh=f bCr1jE7Z2DvgIc+2Ok11gv0w4l1SGRAkJHGeIZsfU8=; b=p6gpQkJ9FJrmHuqr1 7eLx6ABov0TkixBMZT9Of7Iv7KS3+APryeVLLrL10iduVETeXf+VbK5MTGfx6r4X /FS4r1+Qa2wyLxK6KKIImGrn3w8OqIMB4LhOggKxnIOLfAcbe3OOcDwFOMqIGng5 eWm9fZlGbWTqOe9Q9KLdLqsILLugUi/M3jndRKRXkrr1NQXZziYMYOLJk5lu4l1F Ad0bG/d+d3KSI4HpZrDJYi2t4rxWPUQrYnP52hz77roAc8YDqQ6NNgVGHdst8wwt d6W8jnC3N0DST17eCln0vTKIHRrmmbCVOSx1XPfm/+8ediG/m2gLqBXfIOnfnrGZ Pf3ZA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddvtdeigeeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheplmhlvhgrrhho ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtf frrghtthgvrhhnpeetuedvheffkeevgfeuheevteevkefggedttdeufeeuheduuddthfef fffhjeefffenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgv sehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtthhopeehpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopehpvghtvghrsegvihhsvghnthhrrghuthdrohhrghdprhgtphht thhopehjihgrnhdruhhnihhvvghrshgrlhhithihsehgmhgrihhlrdgtohhmpdhrtghpth htoheprhgvshhhkhgvkhhirhhilhhlsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhg shhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepth hglhesshhsshdrphhghhdrphgrrdhush X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 13 Nov 2025 03:24:54 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1763022292; bh=XaXRcyiQReFuO3XOuPSoMJR4L6LavMbk2J7fsfkYECQ=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=mdsVJdNSQgvtvO4zQU5fhL3EPA/Nv/h9IyNWrYeCRGkxUsYYq0RrKTIh/JPgBm2Bu AZBEoMyVittLOkL1piqsmGK30TPv7cV/lr52D1563NZTKJ3r5SyNBCeMV5lTz1zBSW E/5FhY1rTmYRjl2T/ic9mA7lsofWx33t3KfBbJ2tg3aE/ZhHdDR90ryGiYl11D0MUl VpGekZbxyvMxVMLlpJTM/QmbuxLS7YKHxTTawEaZdaoMbqhPXP6IUP78P2acbVVM5U uwa77S4Fd4Ibb7y0hrYmy5XV48LbWZbDVgVm4Sp/4XDK7JJUOVd+O2qi2HoVEEu6do BNPKdaxKY1sIw== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id BEC7276; Thu, 13 Nov 2025 10:24:52 +0200 (EET) Date: Thu, 13 Nov 2025 09:24:52 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: jian he Cc: Peter Eisentraut , Tom Lane , PostgreSQL-development , Kirill Reshke Subject: Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt Message-ID: <202511130823.vppi3clyjl4r@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Nov-13, jian he wrote: > @@ -15658,10 +15658,19 @@ ATPostAlterTypeParse(Oid oldId, Oid oldRelId, Oid refRelId, char *cmd, > querytree_list = list_concat(querytree_list, afterStmts); > } > else if (IsA(stmt, CreateStatsStmt)) > + { > + RangeTblEntry *rte; > + CreateStatsStmt *ss = castNode(CreateStatsStmt, stmt); > + > + rte = makeNode(RangeTblEntry); > + rte->rtekind = RTE_RELATION; > + rte->relid = oldRelId; > + rte->rellockmode = ShareUpdateExclusiveLock; > + ss->rtable = list_make1(rte); > + > querytree_list = lappend(querytree_list, > - transformStatsStmt(oldRelId, > - (CreateStatsStmt *) stmt, > - cmd)); > + transformStatsStmt(ss, cmd)); > + } > else > querytree_list = lappend(querytree_list, stmt); > } Hmm, how would this part here work in the hypothetical world where a stats object references multiple relations? -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "No renuncies a nada. No te aferres a nada."