Postgres Pro
Downloads
Home   >   mailing lists

Note that ALTER TABLE cannot alter generated stored columns - Mailing list pgsql-docs

From Emre Hasegeli
Subject Note that ALTER TABLE cannot alter generated stored columns
Date
Msg-id CAE2gYzw0dUtL4PZ6_zfwyF9yCpejuRMWh_9gFgf3s8YEqxCN0Q@mail.gmail.com
Whole thread Raw
Responses Re: Note that ALTER TABLE cannot alter generated stored columns  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Note that ALTER TABLE cannot alter generated stored columns  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-docs
Tree view 
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.
Attachment

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_type_d.h location incorrect
Next
From: Laurenz Albe
Date:
Subject: Re: Note that ALTER TABLE cannot alter generated stored columns