Dear David,
Thank you very much for your feedback and clarification.
We now realize that the current immutability mechanism in PostgreSQL has been established for a long time, and changing it at this point would not only be difficult but also risk breaking backward compatibility.
We appreciate y
Hi hackers,
Thanks for the valuable feedback on my previous patch.
Based on the review comments, I have updated the patch as follows:
- Limited the error trigger only to the case where the original function is IMMUTABLE but the new definition is not.
- Changed the error code to ERRCODE_FEATURE_N
Hi hackers,
The purpose of this patch is to prevent replacing a function via `CREATE OR
REPLACE FUNCTION` with a new definition that is not marked as `IMMUTABLE`, if
the existing function is referenced by an index expression.
Replacing such functions may lead to index corruption or runtime sema