From: Peter Eisentraut <peter@eisentraut.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add stratnum GiST support function
Date: Fri, 19 Jan 2024 14:47:40 +0000
Message-ID: <E1rQq9k-0029mP-5b@gemulon.postgresql.org> (raw)
Add stratnum GiST support function
This is support function 12 for the GiST AM and translates
"well-known" RT*StrategyNumber values into whatever strategy number is
used by the opclass (since no particular numbers are actually
required). We will use this to support temporal PRIMARY
KEY/UNIQUE/FOREIGN KEY/FOR PORTION OF functionality.
This commit adds two implementations, one for internal GiST opclasses
(just an identity function) and another for btree_gist opclasses. It
updates btree_gist from 1.7 to 1.8, adding the support function for
all its opclasses.
Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Reviewed-by: jian he <jian.universality@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/CA+renyUApHgSZF9-nd-a0+OPGharLQLO=mDHcY4_qQ0+noCUVg@mail....
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/6db4598fcb82a87a683c4572707e522504830a2b
Modified Files
--------------
contrib/btree_gist/Makefile | 6 +-
contrib/btree_gist/btree_gist--1.7--1.8.sql | 87 ++++++++++++++++++++++++++++
contrib/btree_gist/btree_gist.c | 27 +++++++++
contrib/btree_gist/btree_gist.control | 2 +-
contrib/btree_gist/expected/stratnum.out | 13 +++++
contrib/btree_gist/meson.build | 2 +
contrib/btree_gist/sql/stratnum.sql | 3 +
doc/src/sgml/gist.sgml | 65 ++++++++++++++++++++-
doc/src/sgml/xindex.sgml | 8 ++-
src/backend/access/gist/gistutil.c | 14 +++++
src/backend/access/gist/gistvalidate.c | 8 ++-
src/include/access/gist.h | 3 +-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_amproc.dat | 18 ++++++
src/include/catalog/pg_proc.dat | 6 ++
src/test/regress/expected/misc_functions.out | 13 +++++
src/test/regress/sql/misc_functions.sql | 4 ++
17 files changed, 273 insertions(+), 8 deletions(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: peter@eisentraut.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add stratnum GiST support function
In-Reply-To: <E1rQq9k-0029mP-5b@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox