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 1uomVh-00A4lL-Ls for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Aug 2025 17:22:07 +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 1uomVg-00AFoK-DI for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Aug 2025 17:22:05 +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.94.2) (envelope-from ) id 1uomVf-00AFoC-R1 for pgsql-hackers@lists.postgresql.org; Wed, 20 Aug 2025 17:22:04 +0000 Received: from mail-pf1-x431.google.com ([2607:f8b0:4864:20::431]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uomVd-000wrm-2I for pgsql-hackers@postgresql.org; Wed, 20 Aug 2025 17:22:03 +0000 Received: by mail-pf1-x431.google.com with SMTP id d2e1a72fcca58-76e2ebe86ecso228531b3a.3 for ; Wed, 20 Aug 2025 10:22:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1755710519; x=1756315319; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=Cqw9E5+3jauB2VQRG1p5NiwDMnI6utuQ0+LOhv7zYOo=; b=T8kHj3R0DUWQVennILCfsjC8wF9+SM7mwhLtnmiZ3njCPtBRadVLxAuSrnmgIrUFnt HzDCVi3Fwj7WWsMb/gD3rfZtyqGLuW4pA+N7p1Z2Mw63iVymVA1Ya1KEL4BIzgI3qumk 1n5qOSZ4sepvXWtn+jZUjFoOJ82y+rPfxzpuM= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755710519; x=1756315319; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=Cqw9E5+3jauB2VQRG1p5NiwDMnI6utuQ0+LOhv7zYOo=; b=gJwxRqFJuMf25KTOcx3OJxj1MWZEI8hVqXlpaIuHTmJA05Fx+d6BmK+icm+zfQTgoN cBgV49YC7o4RdS21afqlsDGtfDm50qZDGqbtDStNAoV1g2L2nJN0p/aa0/9JmJXYDa/I MXS1rPulcCnwmSCV1915ascFALsovMIv53IRyPeb8t3IjLObvf7FlCIcf7vbS8a/JyZF uq0Ag02yGcdYbpTCHQTAHBLnyXWAYC7h6lVtSmabjgllYtGk//QVvMf3qfFdzxVxS1tf dl7S/JVAarIZlb1eU8R456p/M6c8+/N/kR0tMj0pHhqVbLe/JbDwinRQa3dAJXHhKqeD 6XTA== X-Forwarded-Encrypted: i=1; AJvYcCXukEnXPPLxUCBJqxQWvvvK5lnqheU3R4UfeRtjXr0HQ68jYtKQHckfaHhKzBpPEX6fR5YC0xvcJZr3mfTj@postgresql.org X-Gm-Message-State: AOJu0YyNFF3bol54Zd32EnztS/w+OxnetxlfGrl3kOCQCvXLQzIbrayz k5H6bJa4MZjN2erC6bd/Muuj2VzOOd6gGaU4aXVNjkdZDrtjbQtfK+s9kMsN2gf/Rw== X-Gm-Gg: ASbGncuQV5N7aOQFfj5hI1Obg0eZxVncLuHc0N54afNq9QV/UFTs+CfQ2/zz7oW6BAu 51OyF2I1/B6Dby7Fqfky0psIRBFIoPGzOX0nyNVqpHbP2dvinsUoCHQzfgD2mRBj9PU+b/WTcHo /Cl7xmCzVsAYbKEixFvFiSWQllQHGvX54sE7pX5Gc+xuBF3nZfA0m5k7Wc0m3dWGRnxeT6cM7vG vjhQvB6dGT2ji9BRh9ybgDvQxznpIJVtru43ZHzCGNasTF9De9RpeAYgNGcU3Zfs1Qe5z0QDqZ+ htzO4nnqvjH3Ng16T0nLC/Sa9bdKoosNxTI/EnsLOMzglZ7l6ozu6GyZuQIx9ykHpJRgIbhs+J4 uzbQsc4b8r9fbtb4/IvdEWDY9kM6ZOTy5RSkfymGg3zO+hMxzDf4h9TzOE3t40Q== X-Google-Smtp-Source: AGHT+IGcNfuf/YaeyMZ3Zs5Cl37kvm9nCELzTOX9FtQQROm3qZdSPHvu6tDCRz+7WSKN44AUkbormw== X-Received: by 2002:a05:6a00:4143:b0:76e:885a:c3ea with SMTP id d2e1a72fcca58-76e8dd7564dmr4302825b3a.30.1755710519128; Wed, 20 Aug 2025 10:21:59 -0700 (PDT) Received: from google.com (c-73-15-160-255.hsd1.ca.comcast.net. [73.15.160.255]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-76e7f0b4f34sm5651731b3a.92.2025.08.20.10.21.58 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 20 Aug 2025 10:21:58 -0700 (PDT) Date: Wed, 20 Aug 2025 10:21:56 -0700 From: Noah Misch To: Kirill Reshke Cc: Alexander Lakhin , pgsql-hackers@postgresql.org, Robert Haas Subject: Re: Test instability when pg_dump orders by OID Message-ID: <20250820172156.be.nmisch@google.com> References: <20250718191702.45.nmisch@google.com> <20250725022740.30.nmisch@google.com> <20250804000321.8b.nmisch@google.com> <20250810163659.71.nmisch@google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Aug 20, 2025 at 10:11:15AM +0500, Kirill Reshke wrote: > On Sun, 10 Aug 2025 at 21:37, Noah Misch wrote: > > Thanks. Given the current state of freeze for tomorrow's release wrap, the > > decision is less obvious than usual. I'm seeing these options: > > > > 1. Remove the new assertion in v13-v18. > > 2. Push your proposed fix. > > 3. Change nothing. (This would be the choice if one is maximally concerned > > about deviating from the freeze and unconcerned about --enable-cassert > > builds of releases.) > > > > I am inclined to make today's change be (1). A fresh audit of catalog PRIMARY > > KEY and UNIQUE constraints didn't find any more missed cases, but (1) still > > feels like the right level of cautiousness. If there are no objections in the > > next 3hr, I'll proceed with (1). > > Hi! I can see we have option (1) (28e7252 etc). Can we now move > forward with option (2) for HEAD? Yep. It's in my queue.