Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: kehan5800(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements
Date: 2026-10-07 15:44:06
Message-ID: 2285766.1791387846@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> writes:
> On Tue, 2026-10-06 at 16:06 -0400, Tom Lane wrote:
>> 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!

Pushed, thanks for looking at it!

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Shubhra Jain 2026-10-07 11:04:00 Re: Do we want to avoid checksumming extra files in the datadir? [was: BUG #19647]