0002-Updated-supported-funcs-SQL-for-recent-PostgreSQL.patch
text/x-patch
Filename: 0002-Updated-supported-funcs-SQL-for-recent-PostgreSQL.patch
Type: text/x-patch
Part: 1
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch 0002
Subject: Updated supported funcs SQL for recent PostgreSQL
| File | + | − |
|---|---|---|
| contrib/vci/vci_supported_funcs.sql | 2 | 2 |
From 87b70df29458dab7dfdeac0f7ac1de975e625587 Mon Sep 17 00:00:00 2001
From: Timur Magomedov <t.magomedov@postgrespro.ru>
Date: Thu, 19 Jun 2025 19:55:53 +0300
Subject: [PATCH 2/2] Updated supported funcs SQL for recent PostgreSQL
---
contrib/vci/vci_supported_funcs.sql | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/contrib/vci/vci_supported_funcs.sql b/contrib/vci/vci_supported_funcs.sql
index b80c53085e6..4761173cbf2 100644
--- a/contrib/vci/vci_supported_funcs.sql
+++ b/contrib/vci/vci_supported_funcs.sql
@@ -2,7 +2,7 @@
CREATE TEMPORARY TABLE test (funcoid oid);
INSERT INTO test (funcoid) SELECT unnest(ARRAY[aggfnoid, aggtransfn, aggfinalfn, aggmtransfn, aggminvtransfn, aggmfinalfn]) FROM pg_aggregate;
-INSERT INTO test (funcoid) SELECT unnest(ARRAY[aminsert, ambeginscan, amgettuple, amgetbitmap, amrescan, amendscan, ammarkpos, amrestrpos, ambuild, ambuildempty, ambulkdelete, amvacuumcleanup, amcanreturn, amcostestimate, amoptions]) FROM pg_am;
+INSERT INTO test (funcoid) SELECT amhandler FROM pg_am;
INSERT INTO test (funcoid) SELECT unnest(ARRAY[amproc]) FROM pg_amproc;
INSERT INTO test (funcoid) SELECT unnest(ARRAY[castfunc]) FROM pg_cast;
INSERT INTO test (funcoid) SELECT unnest(ARRAY[conproc]) FROM pg_conversion;
@@ -105,7 +105,7 @@ CREATE FUNCTION print_typename(IN oids _oid) RETURNS _name AS $$
SELECT array_agg(pg_type.typname) FROM unnest(oids) AS t(i), pg_type WHERE i = pg_type.oid;
$$ LANGUAGE SQL;
-SELECT oid, proname, provolatile, prolang, print_typename(array_prepend(prorettype, proargtypes)) FROM pg_proc WHERE NOT proisagg AND NOT proiswindow AND NOT proretset
+SELECT oid, proname, provolatile, prolang, print_typename(array_prepend(prorettype, proargtypes)) FROM pg_proc WHERE prokind = 'f' AND NOT proretset
AND NOT EXISTS (SELECT funcoid FROM sys_func_table WHERE pg_proc.oid = sys_func_table.funcoid)
AND (SELECT bool_and(i IN (SELECT typeoid FROM safe_types)) FROM unnest(array_prepend(prorettype, proargtypes)) AS t(i))
AND oid < 16384 ORDER BY oid;
--
2.43.0