回复:[Internet]Re: Re: 回复:Re: [PATCH] Pr event replacement of a function if it's used in an index expression and is not IMMUTABLE

2025-07-11 Thread sundayjiang()
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

回复:[Internet]Re: [PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE

2025-07-09 Thread sundayjiang()
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

[PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE

2025-06-30 Thread sundayjiang()
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