Re: [HACKERS] generated columns - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: [HACKERS] generated columns
Date
Msg-id 39798611540990901@myt4-174696c9aa9d.qloud-c.yandex.net
Whole thread Raw
In response to Re: [HACKERS] generated columns  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Hi

> OK, so the problem is COPY.
>
> Which means we have an issue with restore. We need to be able to pg_dump a table with generated columns, then restore
itafterwards. More generally, we need to be able to handle data that has already been generated - the "generate" idea
shouldapply to new data not existing data.
 
pg_dump was fixed in published patch (i check this yesterday). It does not COPY generated columns values, only
non-generated.

regards, Sergei


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [HACKERS] generated columns
Next
From: Amit Kapila
Date:
Subject: Re: WIP: Avoid creation of the free space map for small tables