Note that ALTER TABLE cannot alter generated stored columns
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
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