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.94.2) (envelope-from ) id 1s2stW-0073iD-Fa for pgsql-hackers@arkaria.postgresql.org; Fri, 03 May 2024 13:24:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s2stT-009M8D-Ne for pgsql-hackers@arkaria.postgresql.org; Fri, 03 May 2024 13:24:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s2ssg-0099r4-2W for pgsql-hackers@lists.postgresql.org; Fri, 03 May 2024 13:23:18 +0000 Received: from charmander.telsasoft.com ([50.244.222.1] helo=pryzbyj2023.telsasoft) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s2sse-001FFg-4r for pgsql-hackers@lists.postgresql.org; Fri, 03 May 2024 13:23:17 +0000 Received: by pryzbyj2023.telsasoft (Postfix, from userid 1000) id D2C633509; Fri, 3 May 2024 08:23:14 -0500 (CDT) Date: Fri, 3 May 2024 08:23:14 -0500 From: Justin Pryzby To: Dmitry Koval Cc: Alexander Lakhin , Alexander Korotkov , pgsql-hackers@lists.postgresql.org Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands Message-ID: References: <86bfd241-a58c-479a-9a72-2c67a02becf8@postgrespro.ru> <0f655bcd-6487-4179-f9cf-c248efbad510@gmail.com> <41117807-3bea-45bc-a9c0-743c29abff2d@postgrespro.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <41117807-3bea-45bc-a9c0-743c29abff2d@postgrespro.ru> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, May 01, 2024 at 10:51:24PM +0300, Dmitry Koval wrote: > Hi! > > 30.04.2024 23:15, Justin Pryzby пишет: > > Is this issue already fixed ? > > I wasn't able to reproduce it. Maybe it only happened with earlier > > patch versions applied ? > > I think this was fixed in commit [1]. > > [1] https://github.com/postgres/postgres/commit/fcf80c5d5f0f3787e70fca8fd029d2e08a923f91 I tried to reproduce it at fcf80c5d5f~, but couldn't. I don't see how that patch would fix it anyway. I'm hoping Alexander can confirm what happened. The other remaining issues I'm aware of are for EXCLUDING STATISTICS and refusing to ALTER if the owners don't match. Note that the error that led to "EXCLUDING IDENTITY" is being discused over here: https://www.postgresql.org/message-id/3b8a9dc1-bbc7-0ef5-6863-c432afac7d59@gmail.com It's possible that once that's addressed, the exclusion should be removed here, too. -- Justin