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 1xELY2-000000013b3-2MQX for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Oct 2026 06:54:42 +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 1xELY1-00000004yrK-2U9K for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Oct 2026 06:54:41 +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 1xELY1-00000004yrC-1GEI for pgsql-bugs@lists.postgresql.org; Wed, 07 Oct 2026 06:54:41 +0000 Received: from mail-wm1-x330.google.com ([2a00:1450:4864:20::330]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xELXz-00000000mS8-0Q7Q for pgsql-bugs@lists.postgresql.org; Wed, 07 Oct 2026 06:54:40 +0000 Received: by mail-wm1-x330.google.com with SMTP id 5b1f17b1804b1-4a018792ab3so13807445e9.0 for ; Tue, 06 Oct 2026 23:54:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1791356076; x=1791960876; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to:content-type; bh=prfYngpJvyGKhwVqO0MZBH7os9CJKr08mSJ2kZVLulY=; b=RuA4AdYjuUcOzygbIJQ5+61YXqJuW/6naesNcnmeMzyCA+cweSP5lmLzzwURob3Eq3 IrFgvulmBJetFaUWLg+ZFTyvK6KJBVq7BeMjMbaa76PuzSAy+qAUFda9gJO1alzI3xCp bmHwWakDCS3q6odWGhfOsX74eDjOrlsir0GsZEIPh8Wa53edDhRU986bFqWmYes51zqi OXTd8fOX8XHFelKp0414Wl9dcZfvBEL7TR3GGcNnmJRNC//+FCbrBYYa7B+aDq0zywJR /c3DMBAp9Q3fS+0XKK2ADuD3kiOIYr18VIKKWdLHU4AVcBceQ6C6cHjGllv30Mdpdqu2 mlXA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1791356076; x=1791960876; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=prfYngpJvyGKhwVqO0MZBH7os9CJKr08mSJ2kZVLulY=; b=FRNvhNMTIiRamjVYgmxn4J+h38+jH2NpHoSvEdV+OwDZr34CDf0u1p6H40xd27lTIO hggsdxTGmOI+edpwt5fvg0In/k6aCh7PZ32FxKAXXZMoL4cBirwGrtad4U4dZc0thMnl kEpW6v7cK/uZhkzGPSM6ATTYg49c1ruF9zECvoF161pW6Jy7ykqch/WKRJTN+JsFT59h 48rqA7TkWGjgh6ePqPizXHbeGh1A8nFZgEYNaMjQjZ0MkuLoEpDwXX8PWlcQk+L8Q2Aa 2oZ6msfAxI4lOIw9JtTRXGxrUl1pxSdjAkVaGMpdIBsFZWHqYus5P1W2BQP9ROb3bD3T V76A== X-Gm-Message-State: AFuF++l4JaIZKyhubPCL6qxC96S38R+zagJVB6FbnRwdEUR/9iXKi1ZM yqAjkBTAMN4gxzq4f8CMmmMJOTbwXaq3BY3axKxlOwaPPBeAhu4hC8VGW9OJcZSTZH4= X-Gm-Gg: AYBFou2qOXvFQpe4RtUBpJ9YQz1Kfh/8RMwRFHEOZIyuAY4NudoR5a+Bf0U8TWwZSWq TPsIGy5HPNZPW3LsT15WY3CBvgeG/xKw5u3TJfIXpy0raMbi7FRtlQJ9QVY21dqh6Sevnmz58l+ 4CAoOxkPKJLpUjsPsmWuEqnmuQ6T6LNWsvOGrH39iDn5tqImgj6bQtJkgyUgAxdbvEfo/iyOy5Q 1nBkr38x9Dbuosm78I+jkmx7ih9Ko/ZRI0hlvYHpmmnst7FefwSNmSLSbMPY4B/lBIuTYFV0faD bCkGvCpmkznooDXrMWB7q2aPUXidUeJhXFG3V8veZ2Vp1/0fZbS/AFIhzLhbrsCvxHqoouDHkFL 0grnvPb7fQk3UN3O6QatgODbwOUwD50OXdvRzkeMafTR2rj2e962XgQj8XaVLIzgPy72Fo+5g+L lb5lT1hzmSzl+cyok/Kkvz7MzIhuSbx3X4/uOowCIqf0PmN+NRiMWqVaykO2jzNQfdIABim66Zh rV0zP8eeylEUTOWM0RZliQAkV8w X-Received: by 2002:a05:600c:4694:b0:4a0:1fe2:d4f1 with SMTP id 5b1f17b1804b1-4a1806483ddmr17404535e9.28.1791356076442; Tue, 06 Oct 2026 23:54:36 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:8908:76b2:26ac:3777:7531]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4a17f51beffsm44771025e9.2.2026.10.06.23.54.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 06 Oct 2026 23:54:35 -0700 (PDT) Message-ID: <0d93fce2149eb3512ce665f2706e25a410751c95.camel@cybertec.at> Subject: Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements From: Laurenz Albe To: Tom Lane , kehan5800@gmail.com Cc: pgsql-bugs@lists.postgresql.org Date: Wed, 07 Oct 2026 08:54:34 +0200 In-Reply-To: <1503342.1791317207@sss.pgh.pa.us> References: <19747-69b01e7fc190cd58@postgresql.org> <1201948.1791236086@sss.pgh.pa.us> <1503342.1791317207@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2026-10-06 at 16:06 -0400, Tom Lane wrote: > I wrote: > > PG Bug reporting form writes: > > > [misbehavior with array_nulls on] >=20 > > Meh. TBH, that GUC was past its shelf life ten years ago. What > > I'd rather do about this report is just summarily remove the GUC. > > If we make pg_dump issue a SET for it then we'll never be able > > to remove it. >=20 > Concretely, about like this. (BTW, another argument for doing > this rather than fixing pg_dump is that there are a ton of other > applications that will likely misbehave if array_nulls is turned > on underneath them.) +1 I have never seen this used in the field. One less potential headache! Yours, Laurenz Albe