Re: BUG #17036: generated column cann't modifyed auto when update - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17036: generated column cann't modifyed auto when update
Date
Msg-id CAKFQuwarr8b2=2j2J4GuSV-FwqAXq38ebFR_wTUY=Lg9_YLCJg@mail.gmail.com
Whole thread Raw
In response to BUG #17036: generated column cann't modifyed auto when update  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re:Re: BUG #17036: generated column cann't modifyed auto when update  (德哥 <digoal@126.com>)
Re:Re: BUG #17036: generated column cann't modifyed auto when update  (德哥 <digoal@126.com>)
List pgsql-bugs
On Wednesday, May 26, 2021, PG Bug reporting form <noreply@postgresql.org> wrote:
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

why mod_time cann't updated automatic?


Because that isn’t how this thing works...the lie you told it about being immutable is a dead giveaway,

David J.
 

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17036: generated column cann't modifyed auto when update
Next
From: Dmitry Dolgov
Date:
Subject: Re: XX000: iso-8859-1 type of jsonb container.