Home > mailing lists

Re: altering a column to to make it generated - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: altering a column to to make it generated
Date	April 22 22:45:46
Msg-id	CAKFQuwb5i7nW+QcYfpCb2=SnXyURsGXd3_YwEBw61HuB4muv2g@mail.gmail.com Whole thread Raw
In response to	altering a column to to make it generated (Celia McInnis <celia.mcinnis@gmail.com>)
Responses	Re: altering a column to to make it generated (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

On Mon, Apr 22, 2024 at 12:42 PM Celia McInnis <celia.mcinnis@gmail.com> wrote:

Can I alter a table column to now make it generated? I tried this unsuccessfully:

I looked at all of the "alter table ... alter column" commands listed here:

And none seem to involve the generated expression column. So the answer is no.

David J.

From: Celia McInnis
Date: 22 April, 22:42:09
Subject: altering a column to to make it generated

From: Ron Johnson
Date: 22 April, 22:51:54
Subject: Re: CLUSTER vs. VACUUM FULL