I found that provolatile attribute of to_timestamp in pg_proc is wrong: test=# select provolatile, proargtypes from pg_proc where proname = 'to_timestamp' and proargtypes[0] = 701; provolatile | proargtypes -------------+------------- i | 701 (1 row)
'i' (immutable) is clearly wrong since the function's return value can be changed depending on the time zone settings. Actually the manual says functions depending on time zone settings should be labeled STABLE. https://www.postgresql.org/docs/14/xfunc-volatility.html "A common error is to label a function IMMUTABLE when its results depend on a configuration parameter. For example, a function that manipulates timestamps might well have results that depend on the TimeZone setting. For safety, such functions should be labeled STABLE instead." It's intersting that two arguments form of to_timestamp has correct attribute value ('s': stable) for provolatile in pg_proc. Do we want to fix this for PG16? I think it's too late for 15. Best reagards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
