pgsql: Convert built-in SQL-language functions to SQL-standard-body sty

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Convert built-in SQL-language functions to SQL-standard-body sty
Date: 2021-04-16 22:37:15
Message-ID: E1lXX5P-0003n0-2c@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Convert built-in SQL-language functions to SQL-standard-body style.

Adopt the new pre-parsed representation for all built-in and
information_schema SQL-language functions, except for a small
number that can't presently be converted because they have
polymorphic arguments.

This eliminates residual hazards around search-path safety of
these functions, and might provide some small performance benefits
by reducing parsing costs. It seems useful also to provide more
test coverage for the SQL-standard-body feature.

Discussion: https://postgr.es/m/3956760.1618529139@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/767982e36298be4da44a063e36261e9cfdc0bf49

Modified Files
--------------
src/backend/catalog/information_schema.sql | 48 ++--
src/backend/catalog/system_functions.sql | 350 ++++++++++++++++++++++++++---
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 115 +++++-----
4 files changed, 402 insertions(+), 113 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2021-04-16 23:01:28 pgsql: Update dummy prosrc values.
Previous Message Andrew Dunstan 2021-04-16 21:42:14 pgsql: Allow TestLib::slurp_file to skip contents, and use as needed