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 1tG0q6-000Q2t-Lb for pgsql-general@arkaria.postgresql.org; Tue, 26 Nov 2024 19:03: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 1tG0q5-0094ri-51 for pgsql-general@arkaria.postgresql.org; Tue, 26 Nov 2024 19:03:09 +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 1tG0q4-0094ra-OM for pgsql-general@lists.postgresql.org; Tue, 26 Nov 2024 19:03:08 +0000 Received: from mail-wm1-x32e.google.com ([2a00:1450:4864:20::32e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tG0q2-0041fb-52 for pgsql-general@lists.postgresql.org; Tue, 26 Nov 2024 19:03:07 +0000 Received: by mail-wm1-x32e.google.com with SMTP id 5b1f17b1804b1-4314c4cb752so54567015e9.2 for ; Tue, 26 Nov 2024 11:03:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732647784; x=1733252584; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=OxvRs7T5HKM8zODD2N8PBFSfmwMijc+AGwLxl/X1IDQ=; b=PFgsecWaLBLhq8njzzlDYej31WXtH01MxvytIuC0rLwYb6vz+2I2tNw5oh+n1i5STD u5VjR7ZrBZf6piGqJxnrYrS/bRCFV52HssElwGrR/94D8TdTFFGDiG8bMaY/mi3/5pCv kZyZlqRq3k2TRqGnmC+4fi5o0Ruwg0Hjl+ejQfxaCmKc3Mkv0fjhDKG8QZmn+zg8RjIT irFzZN+zPWomL3o5yuYZb1i9Poss/apQJUK7HlJuPIbYelZ902d8NtGf7UPzf8G0BkfJ dutsvzn9xO19pXdVAEuKbXs+9JZiBHLDygEv3xYxYB8aORbxgHPhpEVse31KO/KwXxc8 A8uA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732647784; x=1733252584; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=OxvRs7T5HKM8zODD2N8PBFSfmwMijc+AGwLxl/X1IDQ=; b=Qy0OXuNr+FR6Rupmnvkrxh+cG/nfRR+pDg0fhahJGz2gl8HN6iGDj+VHb0eu32nMeL h7Ssc66IhoG2WBnDvY6seQFPk1NaTu/40yLlSdxcAY6tzBzdQpOcTWaVjOUImcvW2T9Z UBdkteW25iR9KXFrbMiMnHVYgQ8Zu7UAuqE7oEiC++lRLu7ntRgsMuOGjTq1GQEf0Iwh JUFJbf06beQv46M/Z8aTa0uMnDRg6v35XcWb+g4ejK68/ET98pfLHuVEi7fgfBo+6AhA KE8BQjvopgnMohwzIRPiUWfYyP8h2DMnFNfKDxuVIKpWJZ+I1U5gMgjQg1JBmbN4BXil p3Wg== X-Gm-Message-State: AOJu0YzcwHJG/YpRB94+tMORLE67AYfHgZ3kX9sFOrwRMvPWpJDbdmca o94ztiYKLA3AFQMJY6HiwxsWyhscgCRhODjcv5/cTgHRjkg7e/dyJ4Gtww== X-Gm-Gg: ASbGnctNQfSBbv/H/oPJ2NWKRqqB35TxD+W4LaeRnLZ3CNPT4k+VGfmofietMCziTn+ z/T4ud7IgsCvVWoXwwXxsdvkflQ2H7of66WYbs9Qm///coDod/OyysTiU/rFNvuz8ZVrir16bNp pz9zWoxlCrZfmWen0/kDbi9vH/tEeJAfUcmvYJXb8D+zuyeD+hQHwAIgbQfgxZlqNMM0jbfbho/ Dh9lvl66sPCG38rmiPVobIKM3AD7n5dNMwtPX+FoapiN80KkqIEROCHUhqta7tzbjtaFgGw8kHG jsRKuse+CrBFvnC/TAIYkNzINqM= X-Google-Smtp-Source: AGHT+IFaiDuIg0Sbub+jNr1mWB/E3TNMRCI0ZPJJx+/Buj6UO9OxsG4yFTwoelI0V30BhIXU8BClHQ== X-Received: by 2002:a05:600c:4586:b0:434:a10f:9b with SMTP id 5b1f17b1804b1-434a9dc5069mr3879395e9.14.1732647784301; Tue, 26 Nov 2024 11:03:04 -0800 (PST) Received: from smtpclient.apple (143-45-239-77.dyn.cable.qlnet.ch. [77.239.45.143]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-433b4642b8dsm238759665e9.41.2024.11.26.11.03.03 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 26 Nov 2024 11:03:03 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.200.121\)) Subject: Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION From: Paul Foerster In-Reply-To: <78ec2af8-48f2-42c0-b317-cbb77cc5adc8@aklaver.com> Date: Tue, 26 Nov 2024 20:02:33 +0100 Cc: pgsql-general list Content-Transfer-Encoding: quoted-printable Message-Id: References: <5456A1D0-CD47-4315-9C65-71B27E7A2906@gmail.com> <78ec2af8-48f2-42c0-b317-cbb77cc5adc8@aklaver.com> To: Adrian Klaver X-Mailer: Apple Mail (2.3826.200.121) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Adrian, > On 26 Nov 2024, at 17:56, Adrian Klaver = wrote: >=20 > Did you commit the statements? Yes. I have autocommit on, the psql default. > Are you using concurrent sessions to do this? No. I do this in one session. 1. select, 2. drop, 3. add, 4. select. > When you run the query again do you get the same two statements? Yes. I can repeat the above 4 steps as much as I want. The result = remains the same. I would have expected to have an empty result doing = the final repeated select, but it shows exactly the same output. Cheers, Paul