Re: [HACKERS] generated columns

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] generated columns
Дата
Msg-id CAFj8pRApJQfre4zpAx+PR0KHazqzgJDEB=hG9hmdzt16xoaprw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] generated columns  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] generated columns
Список pgsql-hackers
Hi

po 18. 3. 2019 v 8:35 odesílatel Peter Eisentraut <peter.eisentraut@2ndquadrant.com> napsal:
Here is an updated patch with just the "stored" functionality, as discussed.

The actual functionality is much smaller now, contained in the executor.
 Everything else is mostly DDL support, trigger handling, and some
frontend stuff.

probably I found a bug

create table foo(id int, name text);
insert into foo values(1, 'aaa');
alter table foo add column name_upper text generated always as (upper(name)) stored;
update foo set name = 'bbb' where id = 1; -- ok

alter table foo drop column name_upper;
update foo set name = 'bbbx' where id = 1; -- ok

alter table foo add column name_upper text generated always as (upper(name)) stored;
update foo set name = 'bbbxx' where id = 1; -- error

postgres=# update foo set name = 'bbbxx' where id = 1; -- error
ERROR:  no generation expression found for column number 3 of table "foo"

Regards

Pavel








--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Compressed TOAST Slicing
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Compressed TOAST Slicing