Re: Note that ALTER TABLE cannot alter generated stored columns

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: emre(at)hasegeli(dot)com, pgsql-docs(at)postgresql(dot)org
Subject: Re: Note that ALTER TABLE cannot alter generated stored columns
Date: 2021-06-02 15:00:54
Message-ID: de04e560-2ad7-4edb-28cb-99a2f9eab9b4@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 30.05.21 15:25, 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.

I don't follow why you put this documentation under ALTER TABLE ... DROP
EXPRESSION. That action doesn't seem related to what you were hoping to do.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2021-06-02 15:05:10 Re: Simplify COMMENT and SECURITY LABEL documentation
Previous Message Masahiko Sawada 2021-06-02 09:16:08 Re: Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM