Subject: Re: Dumping/restoring fails on inherited generated column
To: Tom Lane <tgl@sss.pgh.pa.us>
References: <15830.1575468847@sss.pgh.pa.us>
 <fd559544-274c-f514-d8bf-358d2c539455@2ndquadrant.com>
 <31905.1575491779@sss.pgh.pa.us>
 <d6ebcc2e-3e6f-6915-6616-70ef665aed66@2ndquadrant.com>
 <24369.1580758361@sss.pgh.pa.us>
 <b1c831dd-d520-5e7f-0304-0eeed39c9996@2ndquadrant.com>
 <CA+fd4k4cHKUmEyHiPHx0QL3T-DXAP8O1CP-hUvo1WX6RwNC=tA@mail.gmail.com>
 <3f272982-0e0d-17a1-3fb6-fedc74197676@2ndquadrant.com>
 <c9848634-76c1-3c21-fc19-f1b7eebb640f@2ndquadrant.com>
 <3169466.1594841366@sss.pgh.pa.us>
 <CA+fd4k4fck6xzsF8mPWeVSZFBLtiA2cQxrPqBaYcoZGc+hZ=JQ@mail.gmail.com>
 <CA+fd4k6pLzrZDQsdsxcS06AwGRf1DgwOw84sFq9oXNw+83nB1g@mail.gmail.com>
 <e87e2efe-c820-c0d3-f7a0-0789beb78ff1@2ndquadrant.com>
 <CAD21AoCfgYKJo3cEhoUr4cKWxmSxi_gdHQDmOJ5XKC-dDc4yBw@mail.gmail.com>
 <e8e3f666-9050-1029-42cf-d0ecfdb8902e@2ndquadrant.com>
 <0f57d5e9-4112-1ba8-64d8-c02062c1e95d@postgrespro.ru>
 <41888c80-e5bd-f9e5-75dc-fb377113168c@2ndquadrant.com>
 <2808494.1611938475@sss.pgh.pa.us>
Cc: Anastasia Lubennikova <a.lubennikova@postgrespro.ru>,
 Masahiko Sawada <sawada.mshk@gmail.com>,
 Masahiko Sawada <masahiko.sawada@2ndquadrant.com>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <2903e1ce-0765-cbeb-dd58-8fab7f6596a3@2ndquadrant.com>
Date: Wed, 3 Feb 2021 16:24:12 +0100
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <2808494.1611938475@sss.pgh.pa.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

On 2021-01-29 17:41, Tom Lane wrote:
> However ... this doesn't solve all the cases noted in this thread.
> In the first example I gave at [1],
> 
> d3=# create table parent (f1 int default 2);
> CREATE TABLE
> d3=# create table child (f1 int default 3) inherits(parent);
> NOTICE:  merging column "f1" with inherited definition
> CREATE TABLE
> d3=# create table child2() inherits(parent);
> CREATE TABLE
> d3=# alter table child2 alter column f1 set default 42;
> ALTER TABLE
> 
> pg_dump still fails to restore child2.f1's non-inherited default.
> That's probably a pre-existing problem, since it doesn't involve
> GENERATED at all, but we shouldn't forget about it.

> [1] https://www.postgresql.org/message-id/660925.1601397436%40sss.pgh.pa.us

I can't tell what the problem is in this example.  I tried with PG11, 
12, and master, and the schema dump comes out with those same four 
commands and they restore correctly AFAICT.

-- 
Peter Eisentraut
2ndQuadrant, an EDB company
https://www.2ndquadrant.com/