BUG #17036: generated column cann't modifyed auto when update
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #17036: generated column cann't modifyed auto when update |
| Дата | |
| Msg-id | 17036-e4d41f4221873a17@postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #17036: generated column cann't modifyed auto when update
|
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17036
Logged by: Zhou Digoal
Email address: digoal@126.com
PostgreSQL version: 14beta1
Operating system: CentOS 7.7 x64
Description:
postgres=> create or replace function im_now () returns timestamptz as $$
select CURRENT_TIMESTAMP;
$$ language sql strict immutable;
CREATE FUNCTION
postgres=> create table t1 (id int primary key, info text, crt_time
timestamp,
mod_time
timestamptz GENERATED ALWAYS AS (im_now()) stored);
CREATE TABLE
postgres=> insert into t1 (id, info, crt_time) values (1,'test', now());
INSERT 0 1
postgres=> select * from t1;
id | info | crt_time | mod_time
----+------+----------------------------+-------------------------------
1 | test | 2021-05-26 16:38:26.675934 | 2021-05-26 16:38:26.675934+08
(1 row)
postgres=> update t1 set info='a' where id=1;
UPDATE 1
postgres=> select * from t1;
id | info | crt_time | mod_time
----+------+----------------------------+-------------------------------
1 | a | 2021-05-26 16:38:26.675934 | 2021-05-26 16:38:26.675934+08
(1 row)
why mod_time cann't updated automatic?
best regards,
digoal
В списке pgsql-bugs по дате отправления: