Request a Demo
Home   >   mailing lists

Re: [patch] ALTER COLUMN SET EXPRESSION [GENERATED|STORED] - Mailing list pgsql-hackers

From jian he
Subject Re: [patch] ALTER COLUMN SET EXPRESSION [GENERATED|STORED]
Date
Msg-id CACJufxEcKjQgQpnadHdLdW-os2VRuy-xe=2tebgK18jDvDFkUQ@mail.gmail.com
Whole thread Raw
In response to Re: [patch] ALTER COLUMN SET EXPRESSION [GENERATED|STORED]  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
Tree view 
hi.

I found a use case for this patch:
If you want to change a column from stored to virtual, or from virtual to
stored, you previously had to drop the column and re-add it as a stored or
virtual generated column. This would break all existing dependencies, requiring
them to be recreated from scratch. With this patch, the process is much more
convenient, as RememberAllDependentForRebuilding is used internally to rebuild
all dependencies automatically.

A rebased patch is attached.


--
jian
https://www.enterprisedb.com/
Attachment

pgsql-hackers by date:

Previous
From: "zengman"
Date:
Subject: Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)
Next
From: Xuneng Zhou
Date:
Subject: Re: Implement waiting for wal lsn replay: reloaded