pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Add stratnum GiST support function 2+ messages / 1 participants [nested] [flat]
* pgsql: Add stratnum GiST support function @ 2024-01-19 14:47 Peter Eisentraut <peter@eisentraut.org> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2024-01-19 14:47 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Add stratnum GiST support function @ 2024-09-17 09:37 Peter Eisentraut <peter@eisentraut.org> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2024-09-17 09:37 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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. (previously committed as 6db4598fcb8, reverted by 8aee330af55; this is essentially unchanged from those) 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/7406ab623fee1addcb21c881afecbe638a0d56e9 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(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-09-17 09:37 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-01-19 14:47 pgsql: Add stratnum GiST support function Peter Eisentraut <peter@eisentraut.org> 2024-09-17 09:37 pgsql: Add stratnum GiST support function Peter Eisentraut <peter@eisentraut.org>
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