MIME-Version: 1.0
References: <CAGD6t7L68jXK6jOLHhyRijSE1y-Y_pic9RZaNyBG+-QY4pa=6Q@mail.gmail.com>
In-Reply-To: <CAGD6t7L68jXK6jOLHhyRijSE1y-Y_pic9RZaNyBG+-QY4pa=6Q@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 22 Apr 2024 12:45:46 -0700
Message-ID: <CAKFQuwb5i7nW+QcYfpCb2=SnXyURsGXd3_YwEBw61HuB4muv2g@mail.gmail.com>
Subject: Re: altering a column to to make it generated
To: Celia McInnis <celia.mcinnis@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000027cae30616b4b142"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwb5i7nW%2BQcYfpCb2%3DSnXyURsGXd3_YwEBw61HuB4muv2g%40mail.gmail.com>
Precedence: bulk

--00000000000027cae30616b4b142
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Apr 22, 2024 at 12:42=E2=80=AFPM 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:

https://www.postgresql.org/docs/current/sql-altertable.html

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

David J.

--00000000000027cae30616b4b142
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Apr 22, 2024 at 12:42=E2=80=AFPM Celia McInnis &lt=
;<a href=3D"mailto:celia.mcinnis@gmail.com">celia.mcinnis@gmail.com</a>&gt;=
 wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Can I alter a table =
column to now make it generated? I tried this unsuccessfully:</div></div></=
blockquote><div><br></div><div><div class=3D"gmail_default" style=3D"font-f=
amily:arial,helvetica,sans-serif">I looked at all of the &quot;alter table =
... alter column&quot; commands listed here:</div><div class=3D"gmail_defau=
lt" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><a href=
=3D"https://www.postgresql.org/docs/current/sql-altertable.html">https://ww=
w.postgresql.org/docs/current/sql-altertable.html</a><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></d=
iv><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-s=
erif">And none seem to involve the generated expression column.=C2=A0 So th=
e answer is no.</div><div class=3D"gmail_default" style=3D"font-family:aria=
l,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif">David J.</div></div></div></div>

--00000000000027cae30616b4b142--