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.96) (envelope-from ) id 1w29Iz-00024t-05 for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 14:52:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w29Ix-00AaWx-0E for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 14:52:27 +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.96) (envelope-from ) id 1w29Iw-00AaWn-2U for pgsql-hackers@lists.postgresql.org; Mon, 16 Mar 2026 14:52:27 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w29Iv-00000000RRK-0TmO for pgsql-hackers@postgresql.org; Mon, 16 Mar 2026 14:52:27 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-7d74c1157a4so4682771a34.1 for ; Mon, 16 Mar 2026 07:52:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773672743; x=1774277543; darn=postgresql.org; h=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=OtNS+sQywNcnAA54pp9HBjEmL0oSdpVH8ftWbPm4Y+Y=; b=BcEE0vOfdETVUh32muJtsP2Jg2l9Fh1IGe1gVXNPv+N7nRtxS3Ekr9Plmn+fBNy11F EHOMRZnOkguBQbGt3H2wyLXzkbJ0XLLGhqlp2etCZIywNKTi8kqUEMih+lFptPgK42+V p7JV6kpWkoSXwYdshWdh+oieASukkt/HO2P5hpktRp9258dNXHVr+dA8vqhiXdMuiS6w SdMsiSSWji07ixGlgDCUPWunZue+QUIUYq2o8ozwvMgblYjXT+ggDj16XBbNYDZgu5EN gOc02uCbf0i6OKzC4q5KCoatmQcuH2PghHRGzRjHzmo7szFr7ORq100u4R4SumHgk6RG /AYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773672743; x=1774277543; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=OtNS+sQywNcnAA54pp9HBjEmL0oSdpVH8ftWbPm4Y+Y=; b=pGIb+GfgsTeYm2JVehF+EhKPUzUp5bmlt9HZqmJdM5ZecAwWc/Tv9Tt572F4SBMvrK YnviLs8F9vI01w4YH8HvxO6l/Jme2vvjQYgUuSAQKmnRK3C805jYhO/Vrulnzy1ltQg7 oDt9u8gUXzccw/dS5Ihqz7mDBqpFz5gfevDnPoTNCvMZvFRa2RYee+zD4vrOk/u70KOB /QIdQlbkAoYGQvjwlSuYa03x99eyUaBS6MngIemZgGJcwlT7iY8mM6Jk2SpU7XzOHi7f ACFWRf/H61ZsIPl/oKlcNGpsZLvzYVw7rMjNPa/YDyelnt0QnjuUtQjOSnTn3F0bOUXM 7tQg== X-Forwarded-Encrypted: i=1; AJvYcCW29aSY4Otn/lgOXA4COikbAYO09BzNsHc28u1tmkXga4En/gL4IRKbXNI/O4PddfWo+N+vUcU0lPN8MgBs@postgresql.org X-Gm-Message-State: AOJu0YzZPGgf7SjaNjDlzioYUt/am+duA8JqvWEbtBgK8WzYODkwV6dP iUoa52zwjH4uBTzWZkXKfBnS/rTidYABIvv60FMQ4qF04f8SmTQXPHJUFDJ9vA== X-Gm-Gg: ATEYQzxsulbUDyXFEh49dOwQ8+9ub3FV7FrJjpwSrqhsuxCGtvANJeXSuLNy5im1oVu B11l6mzX3c+oeurDTiGQ2m6Tl9wARHA2j5yDGU6XkrqSYc37SBI6Fks76CpXHFH03/+7LKPdJSJ qaexcdBW+n/Hcrhm5C5Pn1B1JZWoyIJ696mjXI/1KKK6PZRBTD5Sc1vHZtVyT2hvhQ0UGVYT+/c S4c5oGL6HJT/5itWQ6cxaS6jXEQ1ekVMImXTX66aimnUqQaq6TwVbN1kZVX6X5Etl2LBVsdWy3P F3dDN094YNSLpCH+aYLCahl9fNvpsBt/l8LkWUmV0QESP0lhhQW7t5swE2Uh3u57sGkTfn0U+WR uslRvdQOlayD7o6K/tIE2g/B51udLzMoSMYUeWW0AJ5FI2Le3s67YgQZ6A6T3N7lP4E9Wr6IirH Aio1NG9K2GnYtjLFV43wIklTd/2aA69U7RqR96f4ToOjcIvULojkf+z4bYO5xsA+hVlHzzV7GUJ yTS8LpAomrTsAhJ8A+kvw== X-Received: by 2002:a05:6830:920:b0:7cf:d1eb:f37a with SMTP id 46e09a7af769-7d782526b7fmr8525201a34.18.1773672743574; Mon, 16 Mar 2026 07:52:23 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7d77a763ba8sm9793710a34.2.2026.03.16.07.52.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 16 Mar 2026 07:52:23 -0700 (PDT) Date: Mon, 16 Mar 2026 09:52:21 -0500 From: Nathan Bossart To: Tom Lane Cc: Andrew Dunstan , Mahendra Singh Thalor , PostgreSQL-development Subject: Re: bug: pg_dumpall with --data-only and --clean options is giving an error after some dump Message-ID: References: <2018594.1773591641@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2018594.1773591641@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, Mar 15, 2026 at 12:20:41PM -0400, Tom Lane wrote: > Andrew Dunstan writes: >> Hmm, this looks like behaviour that goes a long way back. Should we >> backpatch this fix? > > I wouldn't bother. At the end of the day you get the same failure > report anyway. Agreed, I don't think back-patching is worth the (probably low) risk. The latest patch for v19 looks good to me. I recently committed some stuff in this area, so I can take care of committing this one, too. -- nathan