public inbox for [email protected]
help / color / mirror / Atom feedFrom: Álvaro Herrera <[email protected]>
To: [email protected]
Subject: pgsql: Add ALTER TABLE ... ALTER CONSTRAINT ... SET [NO] INHERIT
Date: Wed, 05 Mar 2025 12:51:42 +0000
Message-ID: <[email protected]> (raw)
Add ALTER TABLE ... ALTER CONSTRAINT ... SET [NO] INHERIT
This allows to redefine an existing non-inheritable constraint to be
inheritable, which allows to straighten up situations with NO INHERIT
constraints so that thay can become normal constraints without having to
re-verify existing data. For existing inheritance children this may
require creating additional constraints, if they don't exist already.
It also allows to do the opposite, if only for symmetry.
Author: Suraj Kharage <[email protected]>
Reviewed-by: jian he <[email protected]>
Discussion: https://postgr.es/m/CAF1DzPVfOW6Kk=7SSh7LbneQDJWh=PbJrEC_Wkzc24tHOyQWGg@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/f4e53e10b6ce0eedeb98caa4356facb47c7bb9cb
Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 23 +++++-
src/backend/commands/tablecmds.c | 115 +++++++++++++++++++++++++----
src/backend/parser/gram.y | 28 ++++++++
src/include/nodes/parsenodes.h | 2 +
src/test/regress/expected/inherit.out | 131 +++++++++++++++++++++++++++++++++-
src/test/regress/sql/inherit.sql | 79 +++++++++++++++++++-
6 files changed, 359 insertions(+), 19 deletions(-)
reply
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pgsql: Add ALTER TABLE ... ALTER CONSTRAINT ... SET [NO] INHERIT
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox