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.98.2) (envelope-from ) id 1xAuBn-00000002tlD-0YTh for pgsql-bugs@arkaria.postgresql.org; Sun, 27 Sep 2026 19:05:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xAuBl-00000006W4n-48DN for pgsql-bugs@arkaria.postgresql.org; Sun, 27 Sep 2026 19:05:29 +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.98.2) (envelope-from ) id 1xAuBl-00000006W4d-31HL for pgsql-bugs@lists.postgresql.org; Sun, 27 Sep 2026 19:05:29 +0000 Received: from mail-dy2-x1b.google.com ([2607:f8b0:4864:36::1b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xAuBj-00000001Yjs-0ty0 for pgsql-bugs@lists.postgresql.org; Sun, 27 Sep 2026 19:05:28 +0000 Received: by mail-dy2-x1b.google.com with SMTP id 5a478bee46e88-32be7127c64so250937eec.2 for ; Sun, 27 Sep 2026 12:05:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1790535927; x=1791140727; darn=lists.postgresql.org; h=mime-version:content-transfer-encoding:content-type:references :in-reply-to:message-id:date:subject:cc:to:from:from:to:cc:subject :date:message-id:reply-to:content-type; bh=SXUjkfeQhVmpUyLlmcl8Y4u8s6lnFeCmmAd2HU3jXms=; b=ozQi+qk02dPY8PjzgKyXWyIkEpk32BnFivigoGq3cEJKWzLdRAzdJ3UfcoNQE+L3up HC3ohFpeXkiq/456FHkUAFwW+v42Cr89b5u0Dki+fgd9jMSdIMCPc5Tio5oIOTLnehAd srMuxQ+Z6ToxhASlakDliCiLCom3fPnbqKr0suQ9jISdWoC87LyQ+R8mmt4aCMxi83x7 QHzq0eDc4QZk+ty8VsulBdN1DL/+UJ0b1G+WvRGlLPxqoSJAhDXRdns5ZUkumjAu/oKs jfWOke1R2UHQqEVdF70cJll4atuUlnqqm4JUET4Mhk+Pspj5J/rNcthrCXDhxtX7ILCm TomQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1790535927; x=1791140727; h=mime-version:content-transfer-encoding:content-type:references :in-reply-to:message-id:date:subject:cc:to:from:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=SXUjkfeQhVmpUyLlmcl8Y4u8s6lnFeCmmAd2HU3jXms=; b=QMpvULj1zS7dMafusNtJdZfowXejmSlEXMabNhJ75BVmNLIcQumSQ80Goy3kslFlt7 0UyNq0A3nOs0tgDW9a3fa5hRzPWNHFda525uTde00xGKT+GJKxCrvqDMdpcvcMSpYfZW fU5dLhVBxzKwHXkAQKKsg+Anxh2wPgeNwONbLIic7d08qRTtgf39TmAEdbcEbff9EoF9 aZzfqJrjJZRMSG0x+x+EYWcI1ohLcKGBG+AL4sTGenyuoem4qPj3iGRP0t+F/y2N4DEv eCeRKfvs+fTYW/1X/UY4rqirZbhj1k90m/azMbkYYappnzqrY7DbpacBOpHPCrw40Ax5 c8QA== X-Forwarded-Encrypted: i=1; AKwUvBxZsKwS+I48U7IugOFgVwcNyRAcLWan50cOKCMCXALOL2ZFk7eqiGVfOStmfYGGDkC0a3Kqwf5PsjZ/@lists.postgresql.org X-Gm-Message-State: AFuF++nJCTOSxqFEu7c9owU5RAoFpPaTu9UMtbOEJ5fx7LtvGza2bZp0 ouTOZ9neuHwa3qZCmrcwpY4FW4S7z9mtwvklLSi8n+1SmblmybkZkyAF X-Gm-Gg: AYBFou25Ytom4n411b6i97y0IQQss6CfLsRefBmIf5dowTxaic4ykE9+HhPWbuCwUpI R1hUejgRhY9Qv/0VZx2YFRp2EvRa2QYsEbb3q7ieq8ikTZRQxYS7S2O/lzyuKUggQjDLCWHU91S DRNabQdm4BbMV305XtNDOveCtfD2TivxBU9ZlxtYCjbj4Dz7HfuSaOl53dfylIgbb2PpfDzjdRx NlwwtrlxHwYsmIgD0CHlNMvpEOlFFjgbYnOLz5fVpjkvfbz0PVZdXXf1hgPc56Pws32wG8EM1YP n4x5ZOO5WMail4zK74Z8a6UQ2kMX2lMbe677EPggNJmRGtF5/kG6kVka/IKRuPIZcAIEAcVILhh xZhDeKpy1VLsVT0pZv/gXYUXo6Y6lPWlptS2LChq6/upFzvccyCrX3arx2eDwbeoqkbrYS3i6Zt vDjzr3Ut0yNae1NAVONzNA0TN/ZVVTAkjRiP4za2rj7jNpDDbXtUsZtmtqSgk1uZcbD9Lj7awOv SHv5D8xo6n8PeWNer+ftc5mN8uy7hKSkeU+/CLUZTXZnxCrunt5KJ+a9f+6vkPXFBJdUjNtVgIV bIaL/rmDPdK5ukGw4E0Li8ObY2ZqZ6nlgE5exA== X-Received: by 2002:a05:693c:4099:b0:33b:ee8a:2061 with SMTP id 5a478bee46e88-3427169bcc5mr12801016eec.1.1790535925889; Sun, 27 Sep 2026 12:05:25 -0700 (PDT) Received: from 192.168.1.109 ([2803:3c90:cee:ea00:5c3c:7e70:29e3:7a55]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-34144f4eb9esm22497624eec.19.2026.09.27.12.05.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 27 Sep 2026 12:05:25 -0700 (PDT) From: Manu To: Shihao Zhong , pgsql-bugs@lists.postgresql.org Cc: Alexander Lakhin , Alexandre Felipe Subject: Re: BUG #19686: Rolling back SET TABLESPACE + INSERT leads to index corruption Date: Sun, 27 Sep 2026 16:05:23 -0300 Message-ID: <179053592306.831288.2417550388096976182@gmail.com> In-Reply-To: References: Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-09-27, Shihao Zhong wrote: > I think alexandre already had a fix but in a different thread. Maybe > you folks can merge two threads together? > https://commitfest.postgresql.org/patch/7312/ Thanks a lot for the pointer -- I hadn't come across #7312 when I searched before posting, so I appreciate you connecting the two. I'll take a proper look at Alexandre's patch and follow up on that thread so the discussion stays in one place. Manu