git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ce0b0fa) | patch
Allow some exclusion constraints on partitions
2023年7月12日 07:24:43 +0000 (09:24 +0200)
2023年7月12日 07:25:17 +0000 (09:25 +0200)
commit 8c852ba9a4347c4778cc610ad5a9cb50ea701b5c
Allow some exclusion constraints on partitions

Previously we only allowed unique B-tree constraints on partitions
(and only if the constraint included all the partition keys). But we
could allow exclusion constraints with the same restriction. We also
require that those columns be compared for equality, not something
like &&.

Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Reviewed-by: Ronan Dunklau <ronan.dunklau@aiven.io>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Discussion: https://www.postgresql.org/message-id/flat/ec8b1d9b-502e-d1f8-e909-1bf9dffe6fa5@illuminatedcomputing.com
13 files changed:
contrib/btree_gist/Makefile diff | blob | blame | history
contrib/btree_gist/expected/partitions.out [new file with mode: 0644] blob
contrib/btree_gist/meson.build diff | blob | blame | history
contrib/btree_gist/sql/partitions.sql [new file with mode: 0644] blob
doc/src/sgml/ddl.sgml diff | blob | blame | history
src/backend/commands/indexcmds.c diff | blob | blame | history
src/backend/parser/parse_utilcmd.c diff | blob | blame | history
src/test/regress/expected/alter_table.out diff | blob | blame | history
src/test/regress/expected/create_table.out diff | blob | blame | history
src/test/regress/expected/indexing.out diff | blob | blame | history
src/test/regress/sql/alter_table.sql diff | blob | blame | history
src/test/regress/sql/create_table.sql diff | blob | blame | history
src/test/regress/sql/indexing.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /