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 1sMqXB-004ztF-VO for pgsql-bugs@arkaria.postgresql.org; Thu, 27 Jun 2024 14:55:38 +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 1sMqX8-00AcN5-Oh for pgsql-bugs@arkaria.postgresql.org; Thu, 27 Jun 2024 14:55:35 +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 1sMqX8-00AcMa-1H for pgsql-bugs@lists.postgresql.org; Thu, 27 Jun 2024 14:55:34 +0000 Received: from fout8-smtp.messagingengine.com ([103.168.172.151]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMqX5-003Ovy-97 for pgsql-bugs@lists.postgresql.org; Thu, 27 Jun 2024 14:55:32 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfout.nyi.internal (Postfix) with ESMTP id BEAB11380221; Thu, 27 Jun 2024 10:55:29 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 27 Jun 2024 10:55:29 -0400 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-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1719500129; x= 1719586529; bh=iGmxysMzRALM0qu/pidKkKAbUgMFZxxOK5wAgGuNCWc=; b=s l+tZbMMqxWnHhQXIxYFYM82PNOe7vIdf0QMTqTj0DqegTnzkv8EZ/2zRKZ0d+7y5 SWTBBCuZvgG1N7yRtX8u9CmRWmkPhRr6a7VZd2h30rgm5iL4kkabeC/sr6OqWOiP YQX9jwP66hr7p6wE1JNcXyHzShMDPp2pLcIsOoZWYnxQUT2QjgLWOWSUsy+CF56b YNmGKp4TZRn6E7DrNooNOKP8hXiF2SXr1s9e7dXm2SnP+tT/8WCkpPb1pt2kO8Ef f2LSK/viPaGSrWJlCmXCjDFSkVH6Z+ps9gWBvAB9FI2CuA1+frEnW1ZI0ozPMmbS 5sga5BZ6FgV8AxK30oghw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrtdeggdekfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedvkedtffduffdtffffheffhfejjefhgfeiueeukeejkeff gfdufffhudffffeuveenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 27 Jun 2024 10:55:28 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1719500124; bh=FHEIviyWQATtMMdXErsa3P9G6dM9Sa6/85ru6O2LsYI=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=R4kMPeLREmr4dKvqTu7maOvMxCNaQwn0sL5Jw+nVnYe0AptGLqI87nHb+yTBRygrM nrmzsaY64hriQRSYJiv5WfMI7OcjY8+rSUHsBwFjJOzuKntel6Z1v/sEKbQF1NSS7y O2op6my0Y6xBiS+nvoj03iyHU12YtpQDlX0FLz14ZCxfP7WHRiHp19ZM/bQirOnjdq HBRSmFxIBsiozlbcZyujf78ZfbDlNtZhxv8BiwLvMyRzgnq49DTOBmPLWLaHCIDQTT koTWm+oimXAl+7QIoLv5AlYV8B+fak/4Ui5UiXqJDYjK7yfK/XLOUR86cVPUnk0U6j xhd305mfF1A6w== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 2CCA652B; Thu, 27 Jun 2024 07:55:24 -0700 (PDT) Date: Thu, 27 Jun 2024 16:55:24 +0200 From: Alvaro Herrera To: "Daniel Westermann (DWE)" Cc: Laurenz Albe , "exclusion@gmail.com" , "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert Message-ID: <202406271455.bnzf7kxngins@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 2024-Jun-27, Daniel Westermann (DWE) wrote: > Doesn't happen on FreeBSD: Maybe this one uses Postgrs compiled with assertions disabled (would be what I expect in a "production" build). -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "No deja de ser humillante para una persona de ingenio saber que no hay tonto que no le pueda enseñar algo." (Jean B. Say)