Re: Dumping/restoring fails on inherited generated column

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Zhihong Yu <zyu(at)yugabyte(dot)com>, Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>
Subject: Re: Dumping/restoring fails on inherited generated column
Date: 2021-04-26 12:10:44
Message-ID: ac35da1c-e746-ea19-bfc3-84819a4e907d@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 05.02.21 15:18, Peter Eisentraut wrote:
> Anyway, I figured out how to take account of generation expressions with
> different column orders.  I used the same approach that we use for check
> constraints.  The attached patch is good to go from my perspective.

Dusting this off ... this patch should go into the next minor releases.
The attached patch is for master but backpatches without manual
intervention to PG13 and PG12.

Attachment Content-Type Size
v3-0001-Fix-ALTER-TABLE-INHERIT-with-generated-columns.patch text/plain 6.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2021-04-26 12:19:21 Re: Enhanced error message to include hint messages for redundant options error
Previous Message Amit Langote 2021-04-26 12:04:55 Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY