Attempt to clear the compilation warning, overwrite the plpgsql.out file, and
update the patch.
002_cleanup_spl_funccache_v2.patch
Description: Binary data
This patch only addresses the plan cache release for plpgsql (the procedural
language) and does not cover SQL functions.
Since the src/backend/utils/cache/funccache.c file was introduced in PostgreSQL
18, I will first upgrade to version 18,
then figure out how to extend the benefit to SQL funct
That's correct??this is a simple and blunt patch, and it fails to account for
many factors. Initially, I wasn't even sure if this qualified as a distinct
issue. Your solution is far more reasonable, and I will rethink the new
implementation thoroughly based on your approach.
Thanks,
Zeng Man
Sorry for the garbled characters. I am resending the original test results as
an attachment.
case.txt
Description: Binary data
Sorry for the garbled characters. I am resending the original test results as
an attachment.
result.pdf
Description: Binary data
Hi, hackers
I have observed an issue where the CachedPlan corresponding to a
function/procedure is not released when we execute the "DROP
FUNCTION\PROCEDURE" command. A patch to resolve this problem is attached.
A simple test case is as follows:
Step 1 ??
create or replace procedure test_pr
Thanks for your guidance, you are right, I looked at your patch
and combined it with the example to generate a new patch,
which is really better.
Thanks,
Man Zeng
-- Original --
From: "Tom Lane"
v3-fix-incorrect-assertion.patch
Description: Binary data
