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"
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 по дате отправления: