Horton

Re: Dumping/restoring fails on inherited generated column

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-05-08T09:47:22Z
Lists: pgsql-hackers 
On 2020-05-06 16:29, Peter Eisentraut wrote:
> On 2020-04-23 08:35, Masahiko Sawada wrote:
>> After investigating this issue, I think that current DDLs regarding
>> inherited tables and generated columns seem not to work fine.
> 
> Right, there were a number of combinations that were not properly
> handled.  The attached patch should fix them all.  It's made against
> PG12 but also works on master.  See contained commit message and
> documentation for details.

committed to master and PG12

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Fix ALTER TABLE / INHERIT with generated columns

  2. pg_dump: Fix dumping of inherited generated columns

  3. Disallow ALTER TABLE ONLY / DROP EXPRESSION

  4. Fix several DDL issues of generated columns versus inheritance