Re: BUG #17036: generated column cann't modifyed auto when update

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 德哥 <digoal(at)126(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17036: generated column cann't modifyed auto when update
Date: 2021-05-27 13:45:57
Message-ID: 1709810.1622123157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?GBK?B?tcK45w==?= <digoal(at)126(dot)com> writes:
> If the value of the immutable function changes, the immutable function should be recalculated.

You misunderstand completely. An immutable marking on a function is a
promise from you to the system that the function's value does NOT change.
Therefore, the predicate of your statement is vacuous, and we need not
discuss whether the conclusion is interesting. If there's some behavior
that you don't like as a consequence of your lie, then stop lying.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-05-27 13:56:05 Re: CR is not removed with psql -f command on Windows.
Previous Message Dmitry Dolgov 2021-05-27 10:53:28 Re: XX000: unknown type of jsonb container.