Re: v18 virtual columns
| От | Ron Johnson |
|---|---|
| Тема | Re: v18 virtual columns |
| Дата | |
| Msg-id | CANzqJaC0LCgK1RRKJ=qNTGxgkfFV-_F6keKmCxGBS6EWZ2jjKA@mail.gmail.com обсуждение исходный текст |
| Ответ на | v18 virtual columns (Dominique Devienne <ddevienne@gmail.com>) |
| Ответы |
Re: v18 virtual columns
|
| Список | pgsql-general |
On Thu, Feb 20, 2025 at 8:07 AM Dominique Devienne <ddevienne@gmail.com> wrote:
Hi. I've just read https://www.dbi-services.com/blog/postgresql-18-virtual-generated-columns/and I'm wondering whether there will be a way to ALTER existing STORED generated columns, to be virtual? W/o rewriting the whole table that is.
What about dropping the existing stored column then adding the new virtual column?
You won't get any disk space saving for existing records, but it's not going to rewrite the table.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-general по дате отправления: