Note that ALTER TABLE cannot alter generated stored columns

2021-05-30 Thread Emre Hasegeli
I was trying to change the generation expression of a generated stored
column using ALTER TABLE.  It took me a while before I figured SET
GENERATED applies only to generated identity columns.  I think it'd be
useful to note this in the documentation with something like the
attached.


0001-doc-Note-that-ALTER-TABLE-cannot-alter-generated-sto.patch
Description: Binary data


Re: Note that ALTER TABLE cannot alter generated stored columns

2021-05-30 Thread Laurenz Albe
On Sun, 2021-05-30 at 16:25 +0300, Emre Hasegeli wrote:
> I was trying to change the generation expression of a generated stored
> column using ALTER TABLE.  It took me a while before I figured SET
> GENERATED applies only to generated identity columns.  I think it'd be
> useful to note this in the documentation with something like the
> attached.

+1

Yours,
Laurenz Albe