From: Chao Li <li.evan.chao@gmail.com>
Message-Id: <C3E25893-E862-4EA4-825C-BEB5CE3B62C2@gmail.com>
Content-Type: multipart/mixed;
	boundary="Apple-Mail=_A16E592C-84A0-4462-AED0-7D7DFC34EAC9"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.300.41.1.7\))
Subject: Re: docs: clarify ALTER TABLE behavior on partitioned tables
Date: Mon, 26 Jan 2026 12:15:27 +0800
In-Reply-To: <CAKFQuwZwAuO3qXEeqxwV6vM+89BkB-aSkcXqDGG8e_xBy_Q3Xw@mail.gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>,
 Postgres hackers <pgsql-hackers@lists.postgresql.org>,
 Zsolt Parragi <zsolt.parragi@percona.com>
References: <CAEoWx2=mYhCfsnHaN96Qqwq5b0GVS2YgO3zpVqPPRd_iO52wRw@mail.gmail.com>
 <90F9169D-135C-45E5-8221-4F79DAED98E2@gmail.com>
 <CAKFQuwbWNCX1M1e9_-3P9RVGo10huPjuqdL74FJ+-a5EW791KA@mail.gmail.com>
 <D559C6FA-E101-47F3-BCDF-CEA7FFDF6154@gmail.com>
 <CAKFQuwZ+o6La5DyK9_-L2gpeiKNvGMbR78UjocO4++JkyZaRHw@mail.gmail.com>
 <A8FA43A6-415E-421A-B3EC-CAB68756975D@gmail.com>
 <CAKFQuwabxFyFQob=RfKOV3upjxwomAzmGzSouN-h2ypuXz+dZg@mail.gmail.com>
 <46DA7611-C18D-4782-AEFF-F861ECDEFA5C@gmail.com>
 <CAKFQuwZaquUrTOhfmJ2CenwiyAHx4nORQ0kB01sL+z5pCBuLFQ@mail.gmail.com>
 <CAEoWx2mUiCYJEBuo5D74gi7pHfNz82b54oDHjZNtrXRFDnBPOg@mail.gmail.com>
 <CAKFQuwbQ=L8w8jEaB8_gW-RrNv2_V-VrFYBump7__z-vh-QJWw@mail.gmail.com>
 <CAEoWx2nwoBtWX3=UOQQpGZOuRH5vNv2PHqeFHqDPdiKGaOigiA@mail.gmail.com>
 <CAKFQuwZyJNBN+N5Qtcg0aG6ZpOFvQV5m=cALLgv7g3u1Sz-tZw@mail.gmail.com>
 <245AA9F3-7577-46D6-990C-C308A9F36E82@gmail.com>
 <CAKFQuwZr_GLBOOLohfEcKVVTcP9D+nzVdUUKabYbXWXRnOFjnA@mail.gmail.com>
 <CAEoWx2=CK=QEvpL5HSgFEuFqjO2Q1sDy6a2G-s-+zv+RzB3mTw@mail.gmail.com>
 <CAN4CZFNoLSUcVKcOOJgOtTkDuOseCL5j9MQr3tGjb3btD=jHNQ@mail.gmail.com>
 <CAKFQuwZwAuO3qXEeqxwV6vM+89BkB-aSkcXqDGG8e_xBy_Q3Xw@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/C3E25893-E862-4EA4-825C-BEB5CE3B62C2%40gmail.com>
Precedence: bulk


--Apple-Mail=_A16E592C-84A0-4462-AED0-7D7DFC34EAC9
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8


> On Jan 24, 2026, at 08:57, David G. Johnston =
<david.g.johnston@gmail.com> wrote:
>=20
> Thank you for the review!
>=20
> On Fri, Jan 23, 2026 at 3:07=E2=80=AFAM Zsolt Parragi =
<zsolt.parragi@percona.com> wrote:
> + When applied to a partitioned table, the constraint is altered on =
the
> + partitioned table definition is implicitly applied to all =
partitions.
>=20
> an "and" is missing here (definition and is)
>=20
> Correct.  But I'd go with:
>=20
> ...the constraint is altered on the partitioned table and implicitly =
applied to all partitions.
>=20

Fixed with David=E2=80=99s version.

> +      When applied to a partitioned table, partition columns =
constraints
> +      are implicitly renamed and specifying <literal>ONLY</literal>
> is not allowed.
> +     </para>
>=20
> "partition columns constraints" - that seems like a strange/unclear
> wording to me. maybe ", the partition's column constraints are ... " ?
>=20
> This is just wrong - only is not permitted for either columns or =
constraints.  Only cannot be implicit if cascading is allowed.
> The unclear wording noted is just missing an "and" - of the three =
things that can be renamed (relation name, column name, constraint name) =
only these two apply.
> "the partition columns and constraints..."
>=20
>      <para>
>       When applied to a partitioned table, partition columns and =
constraints
>       are implicitly renamed.
>       Specifying <literal>ONLY</literal> is not allowed, and this =
command
>       cannot be used on individual partitions.
>      </para>
>      <para>
>       For inheritance setups, index-based constraints are always =
considered
>       independent.  ~~Dependent columns and constraints are implicitly =
renamed
>       and specifying <literal>ONLY</literal> is not allowed.~~
>      </para>
>=20
> The last sentence is redundant with the notes though, I'd remove it as =
noted above:
>=20
>    <para>
>     For inheritance setups, the behavior described for partitioned =
tables applies
>     only to the dependent column(s) on the descendant table(s).  It is =
always
>     allowed to target a descendant table with column altering commands =
on independent
>     columns.
>    </para>
>=20
> But that note should have "dependent constraints" added to it.
>=20

I added the missing =E2=80=9Cand=E2=80=9D. And updated the =E2=80=9Cfor =
inheritance=E2=80=9D paragraph as suggested.

But for "Specifying <literal>ONLY</literal> is not allowed, and this =
command, cannot be used on individual partitions.=E2=80=9D, that =
doesn=E2=80=99t seem correct. See my test:
```
evantest=3D# create table root (i int, j int) partition by list(i);
CREATE TABLE
evantest=3D# create table p1 partition of root for values in (1);
CREATE TABLE
evantest=3D# alter table p1 rename to pp1; <=3D=3D Rename a partition is =
allowed.
ALTER TABLE
evantest=3D# alter table only pp1 rename to p1; <=3D=3D ONLY can be =
used, but just no effect
ALTER TABLE
```

> +     <para>
> +      When applied to a partitioned table <literal>ONLY</literal> is =
implicit,
> +      these forms must be applied separately to the partitioned table =
and/or to
> +      individual partitions.
> +     </para>
>=20
> "When applied to a partitioned table, <literal>ONLY</literal> is
> implicit and ..."  (at multiple places, this is an example)
>=20
> I've grown unfond of my suggested wording here during reviews too.  =
But because it's too wordy and a bit redundant.
>=20
> "When applied to a partitioned table ONLY is implicit, however, this =
command can be used on individual partitions."
>=20
> has a better symmetry with:
>=20
> Specifying <literal>ONLY</literal> is not allowed, and this command =
cannot be used on individual partitions.
>=20
>=20
> "A nonrecursive DROP COLUMN (i.e., ALTER TABLE ONLY ... DROP COLUMN)
> never removes any descendant columns, but instead marks them as
> independently defined rather than inherited."
>=20
> This part is now undocumented, it was only mentioned in this =
paragraph.
>=20
> True, it's left implied instead of explicitly stated.  Any column that =
exists on a child but not the parent is by definition "independently =
defined".  So if either ONLY is supplied or the rules for cascading =
delete are not met the result is children with independently defined =
columns with that name.  The original note was wrong anyway for the =
two-parent case - the second parent prevents the marking as independent =
when the first parent's column is dropped.
>=20
>=20
> > C2 - Sub-commands where using them with a partitioned table will =
automatically propagate to child partitions; ONLY prevents propagation; =
new partitions inherit the parent=E2=80=99s new setting; and child =
partitions can be set to different values than the parent.
>=20
> The documentation of this group is inconsistent.
>=20
> DROP CONSTRAINT mentions that individual partitions can be dropped =
separately:
>=20
> +      When applied to a partitioned table, the constraint is dropped =
from
> +      all existing partitions unless <literal>ONLY</literal> is =
specified.
> +      Individual partitions may drop constraints independently of the
> +      partitioned table.
>=20
> But most of the sub commands in the C2 group leave the last sentence
> out, and also the C7 (ADD table_constraint)
>=20
> I didn't try and verify this dynamic or keep to it - though am on =
board with considering changes that do so and remain accurate.
>=20
>=20
> Also, isn't DROP CONSTRAINT on a partition limited to constraints
> defined on that partition? So it would be better to say "may drop
> constraints defined directly on that individual partition
> independently".
>=20
> "When applied to a partitioned table, dependent constraints are =
dropped from ... is specified." should suffice.
> I'd be fine leaving out the entire "Individual partitions may drop..." =
business with that wording.  It implies partitions may have independent =
constraints which by extension may be targeted. =20
>=20
> For Add Constraint - mention dependent constraints
> "When applied to a partitioned table, the constraint is added to the =
partitioned table and dependent constraints are added to all =
partitions."
>=20
> Which implies independent ones may exist and the logic for drop =
constraint then follows.
> (We should explain what happens if a partition already has an =
independent constraint of the given name as that would be relevant =
here.)
>=20
>=20
>   CREATE TABLE parent (id int, val int) PARTITION BY RANGE (id);
>   ALTER TABLE parent ADD CONSTRAINT val_positive CHECK (val > 0);
>   CREATE TABLE child PARTITION OF parent FOR VALUES FROM (1) TO (100);
>   ALTER TABLE child DROP CONSTRAINT val_positive;
>   -- ERROR: cannot drop inherited constraint "val_positive" of =
relation "child"

This is true. I updated the paragraph for DROP CONSTRAINT as:
```
     <para>
      When applied to a partitioned table, the constraint is dropped =
from
      all existing partitions unless <literal>ONLY</literal> is =
specified.
      Dropping an inherited constaint from an individual partition is =
not allowed.
     </para>
```

>=20
> +      When a new partition is created, it generally inherits the =
current
> +      definition-level properties of the parent partitioned table.
>=20
> Maybe something like the following?
>=20
> When a new partition is created, it generally inherits structural
> properties of the parent partitioned table, such as column
> definitions, constraints, and storage settings.
>=20
> To be more explicit about what's inherited, and not only focus on
> what's not. (The commit message also says that the change describes
> both what's inherited and what's not inherited)
>=20
> I concur with the premise but how about:
>=20
>       When a partition is created, it inherits many of the properties
>       of the parent table.  However, properties related to ownership,
>       schema, replica identity, row-level security configuration,
>       per-attribute statistics targets, and per-attribute options
>       are not inherited.
>=20
> "new" is superfluous on this page.
> "definition-level" are the only kind of properties that exist - I'm =
not being wordy thinking people might believe properties includes data.
> "parent" suffices as well.
> We did all the work to identify things - use "however" instead of "in =
particular" to give us credit for the work.
> Even if a property is explicitly set for the partition it isn't =
"inherited" - the partition has its own independent value that in a rare =
case might happen to match the parent at the time of creation. (i.e., =
remove automatically and 'not inherited unless')
> I'm not that inclined to mention the inclusion list.  The general =
premise of assuming inherited unless told otherwise works fine here; =
minimal future-proofing.
>=20

I=E2=80=99m also not included to mention the inclusion list. My other =
patch [1] is changing replica identity to be inherited. Go forward, the =
inclusion list should shrink.

So updated with David=E2=80=99s version.

PFA v7.

[1] =
https://postgr.es/m/CAEoWx2nJ71hy8R614HQr7vQhkBReO9AANPODPg0aSQs74eOdLQ@ma=
il.gmail.com

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/


--Apple-Mail=_A16E592C-84A0-4462-AED0-7D7DFC34EAC9
Content-Disposition: attachment;
	filename=v7-0001-docs-clarify-ALTER-TABLE-behavior-on-partitioned-.patch
Content-Type: application/octet-stream;
	x-unix-mode=0644;
	name="v7-0001-docs-clarify-ALTER-TABLE-behavior-on-partitioned-.patch"
Content-Transfer-Encoding: quoted-printable

=46rom=20ab1bf0fb9c433180ef9af253849be7d85ed2b3fb=20Mon=20Sep=2017=20=
00:00:00=202001=0AFrom:=20Chao=20Li=20<lic@highgo.com>=0ADate:=20Wed,=20=
7=20Jan=202026=2014:50:36=20-0700=0ASubject:=20[PATCH=20v7]=20docs:=20=
clarify=20ALTER=20TABLE=20behavior=20on=20partitioned=20tables=0A=0A=
Document=20how=20individual=20ALTER=20TABLE=20sub-commands=20behave=20=
when=20applied=20to=0Apartitioned=20tables.=0A=0AThe=20existing=20ALTER=20=
TABLE=20documentation=20provides=20limited=20or=20incomplete=0A=
information=20about=20how=20commands=20interact=20with=20partitioned=20=
tables,=20leaving=0Ausers=20to=20infer=20behavior=20from=20=
experimentation.=20This=20patch=20systematically=0Aclarifies,=20for=20=
each=20relevant=20sub-command,=20whether=20changes=20propagate=20to=0A=
existing=20partitions,=20can=20be=20applied=20independently=20to=20=
partitions,=20and=0Ahow=20the=20ONLY=20keyword=20behaves.=0A=0AIn=20=
addition,=20clarify=20in=20CREATE=20TABLE=20documentation=20which=20=
parent=20table=0Asettings=20are=20inherited=20by=20newly=20created=20=
partitions=20and=20which=20are=20not.=0AThis=20makes=20explicit=20that=20=
while=20most=20definition-level=20properties=20are=0Ainherited=20from=20=
the=20partitioned=20table,=20certain=20per-relation=20settings=0A(such=20=
as=20ownership,=20schema,=20replica=20identity,=20row-level=20security,=20=
and=0Aper-attribute=20statistics/options)=20are=20not,=20unless=20=
explicitly=20specified.=0A=0ANo=20behavior=20is=20changed=20by=20this=20=
patch;=20it=20is=20purely=20a=20documentation=20update=0Aintended=20to=20=
make=20existing=20semantics=20explicit=20and=20easier=20to=20understand.=0A=
=0AAuthor:=20Chao=20Li=20<lic@highgo.com>=0AAuthor:=20David=20G.=20=
Johnston=20<David.G.Johnston@Gmail.com>=0AReviewed-by:=20David=20G.=20=
Johnston=20<David.G.Johnston@Gmail.com>=0AReviewed-by:=20Zsolt=20Parragi=20=
<zsolt.parragi@percona.com>=0ADiscussion:=20=
https://postgr.es/m/CAEoWx2=3DmYhCfsnHaN96Qqwq5b0GVS2YgO3zpVqPPRd_iO52wRw@=
mail.gmail.com=0A---=0A=20doc/src/sgml/ref/alter_table.sgml=20=20|=20319=20=
+++++++++++++++++++++--------=0A=20doc/src/sgml/ref/create_table.sgml=20=
|=20=20=207=20+=0A=202=20files=20changed,=20236=20insertions(+),=2090=20=
deletions(-)=0A=0Adiff=20--git=20a/doc/src/sgml/ref/alter_table.sgml=20=
b/doc/src/sgml/ref/alter_table.sgml=0Aindex=201bd479c917a..f72644a098d=20=
100644=0A---=20a/doc/src/sgml/ref/alter_table.sgml=0A+++=20=
b/doc/src/sgml/ref/alter_table.sgml=0A@@=20-171,6=20+171,12=20@@=20WITH=20=
(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20is=20specified=20and=20a=20column=20already=20exists=20with=20this=20=
name,=0A=20=20=20=20=20=20=20no=20error=20is=20thrown.=0A=20=20=20=20=20=20=
</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20applied=20=
to=20a=20partitioned=20table,=20the=20column=20is=20added=20to=20the=0A+=20=
=20=20=20=20=20partitioned=20table=20definition=20and=20is=20implicitly=20=
added=20to=20all=0A+=20=20=20=20=20=20partitions.=20Specifying=20=
<literal>ONLY</literal>=20is=20not=20allowed,=20and=0A+=20=20=20=20=20=20=
this=20command=20cannot=20be=20used=20on=20individual=20partitions.=0A+=20=
=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20=
</varlistentry>=0A=20=0A@@=20-190,6=20+196,18=20@@=20WITH=20(=20MODULUS=20=
<replaceable=20class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=
=20=20=20=20=20=20=20does=20not=20exist,=20no=20error=20is=20thrown.=20=
In=20this=20case=20a=20notice=0A=20=20=20=20=20=20=20is=20issued=20=
instead.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=
=20=20=20When=20applied=20to=20a=20partitioned=20table,=20the=20column=20=
is=20removed=20from=20the=0A+=20=20=20=20=20=20partitioned=20table=20=
definition=20and=20is=20implicitly=20removed=20from=20all=0A+=20=20=20=20=
=20=20partitions.=20Specifying=20<literal>ONLY</literal>=20is=20not=20=
allowed,=20and=0A+=20=20=20=20=20=20this=20command=20cannot=20be=20used=20=
on=20individual=20partitions.=0A+=20=20=20=20=20</para>=0A+=20=20=20=20=20=
<para>=0A+=20=20=20=20=20=20For=20inheritance=20setups,=20a=20descendant=20=
column=20is=20removed=20only=20if=20all=20the=0A+=20=20=20=20=20=20=
following=20are=20true:=20ONLY=20is=20not=20specified,=20no=20other=20=
parent=20defines=20the=0A+=20=20=20=20=20=20column,=20and=20the=20column=20=
is=20not=20marked=20as=20having=20been=20independent.=0A+=20=20=20=20=20=20=
Otherwise,=20the=20descendant=20column=20is=20instead=20marked=20as=20=
having=20been=20independent.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-211,7=20+229,6=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20clause=20must=20be=20provided=20if=20there=20is=20no=20implicit=20=
or=20assignment=0A=20=20=20=20=20=20=20cast=20from=20old=20to=20new=20=
type.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=
=20=20=20=20=20When=20this=20form=20is=20used,=20the=20column's=20=
statistics=20are=20removed,=0A=20=20=20=20=20=20=20so=20running=20<link=20=
linkend=3D"sql-analyze"><command>ANALYZE</command></link>=0A@@=20-219,6=20=
+236,12=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20For=20a=20virtual=20generated=20column,=20=
<command>ANALYZE</command>=0A=20=20=20=20=20=20=20is=20not=20necessary=20=
because=20such=20columns=20never=20have=20statistics.=0A=20=20=20=20=20=20=
</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20applied=20=
to=20a=20partitioned=20table,=20the=20data=20type=20change=20is=20=
applied=0A+=20=20=20=20=20=20to=20the=20partitioned=20table=20definition=20=
and=20is=20implicitly=20applied=20to=20all=0A+=20=20=20=20=20=20=
partitions.=20Specifying=20<literal>ONLY</literal>=20is=20not=20allowed,=0A=
+=20=20=20=20=20=20and=20this=20command=20cannot=20be=20used=20on=20=
individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-232,6=20+255,10=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20or=20<command>UPDATE</command>=20commands;=20it=20does=20not=20=
cause=20rows=20already=0A=20=20=20=20=20=20=20in=20the=20table=20to=20=
change.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=
=20=20=20When=20applied=20to=20a=20partitioned=20table,=20the=20default=20=
value=20is=20propagated=0A+=20=20=20=20=20=20to=20all=20partitions=20=
unless=20<literal>ONLY</literal>=20is=20specified.=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
@@=20-242,7=20+269,6=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20These=20forms=20change=20whether=20a=20column=20is=20marked=20to=20=
allow=20null=0A=20=20=20=20=20=20=20values=20or=20to=20reject=20null=20=
values.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=
=20=20=20=20=20<literal>SET=20NOT=20NULL</literal>=20may=20only=20be=20=
applied=20to=20a=20column=0A=20=20=20=20=20=20=20provided=20none=20of=20=
the=20records=20in=20the=20table=20contain=20a=0A@@=20-255,18=20+281,18=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20If=20a=20column=20has=20an=20invalid=20not-null=20constraint,=0A=20=
=20=20=20=20=20=20<literal>SET=20NOT=20NULL</literal>=20validates=20it.=0A=
=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A-=20=20=20=20=20=
=20If=20this=20table=20is=20a=20partition,=20one=20cannot=20perform=20=
<literal>DROP=20NOT=20NULL</literal>=0A-=20=20=20=20=20=20on=20a=20=
column=20if=20it=20is=20marked=20<literal>NOT=20NULL</literal>=20in=20=
the=20parent=0A-=20=20=20=20=20=20table.=20=20To=20drop=20the=20=
<literal>NOT=20NULL</literal>=20constraint=20from=20all=20the=0A-=20=20=20=
=20=20=20partitions,=20perform=20<literal>DROP=20NOT=20NULL</literal>=20=
on=20the=20parent=0A-=20=20=20=20=20=20table.=20=20Even=20if=20there=20=
is=20no=20<literal>NOT=20NULL</literal>=20constraint=20on=20the=0A-=20=20=
=20=20=20=20parent,=20such=20a=20constraint=20can=20still=20be=20added=20=
to=20individual=20partitions,=0A-=20=20=20=20=20=20if=20desired;=20that=20=
is,=20the=20children=20can=20disallow=20nulls=20even=20if=20the=20parent=0A=
-=20=20=20=20=20=20allows=20them,=20but=20not=20the=20other=20way=20=
around.=20=20It=20is=20also=20possible=20to=20drop=0A-=20=20=20=20=20=20=
the=20<literal>NOT=20NULL</literal>=20constraint=20from=20=
<literal>ONLY</literal>=0A-=20=20=20=20=20=20the=20parent=20table,=20=
which=20does=20not=20remove=20it=20from=20the=20children.=0A+=20=20=20=20=
=20=20If=20this=20table=20is=20a=20partition,=20one=20cannot=20perform=0A=
+=20=20=20=20=20=20<literal>DROP=20NOT=20NULL</literal>=20on=20a=20=
column=20if=20it=20is=20marked=0A+=20=20=20=20=20=20<literal>NOT=20=
NULL</literal>=20in=20the=20parent=20table.=20To=20drop=20the=0A+=20=20=20=
=20=20=20<literal>NOT=20NULL</literal>=20constraint=20from=20all=20=
partitions,=20perform=0A+=20=20=20=20=20=20<literal>DROP=20NOT=20=
NULL</literal>=20on=20the=20parent=20table.=20Even=20if=20there=20is=0A+=20=
=20=20=20=20=20no=20<literal>NOT=20NULL</literal>=20constraint=20on=20=
the=20parent,=20such=20a=0A+=20=20=20=20=20=20constraint=20can=20still=20=
be=20added=20to=20individual=20partitions;=20that=20is,=20the=0A+=20=20=20=
=20=20=20children=20can=20disallow=20nulls=20even=20if=20the=20parent=20=
allows=20them,=20but=20not=0A+=20=20=20=20=20=20the=20other=20way=20=
around.=20It=20is=20also=20possible=20to=20apply=0A+=20=20=20=20=20=20=
<literal>SET=20NOT=20NULL</literal>=20or=20<literal>DROP=20NOT=20=
NULL</literal>=20to=0A+=20=20=20=20=20=20<literal>ONLY</literal>=20the=20=
parent=20table.=0A=20=20=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=
=20=20=20=20</varlistentry>=0A@@=20-279,7=20+305,6=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20in=20a=20stored=20generated=20column=20is=20rewritten=20and=20all=20=
the=20future=20changes=0A=20=20=20=20=20=20=20will=20apply=20the=20new=20=
generation=20expression.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=
=20<para>=0A=20=20=20=20=20=20=20When=20this=20form=20is=20used=20on=20a=20=
stored=20generated=20column,=20its=20statistics=0A=20=20=20=20=20=20=20=
are=20removed,=20so=20running=0A@@=20-288,6=20+313,11=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20For=20a=20virtual=20generated=20column,=20=
<command>ANALYZE</command>=0A=20=20=20=20=20=20=20is=20not=20necessary=20=
because=20such=20columns=20never=20have=20statistics.=0A=20=20=20=20=20=20=
</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20applied=20=
to=20a=20partitioned=20table,=20the=20generation=20expression=20is=0A+=20=
=20=20=20=20=20propagated=20to=20all=20partitions=20unless=20=
<literal>ONLY</literal>=0A+=20=20=20=20=20=20is=20specified.=0A+=20=20=20=
=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=
=20=0A@@=20-299,17=20+329,21=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20Existing=20data=20in=20the=20columns=20is=20retained,=20but=20=
future=20changes=20will=20no=0A=20=20=20=20=20=20=20longer=20apply=20the=20=
generation=20expression.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=
=20<para>=0A=20=20=20=20=20=20=20This=20form=20is=20currently=20only=20=
supported=20for=20stored=20generated=20columns=20(not=0A=20=20=20=20=20=20=
=20virtual=20ones).=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20=
<para>=0A=20=20=20=20=20=20=20If=20<literal>DROP=20EXPRESSION=20IF=20=
EXISTS</literal>=20is=20specified=20and=20the=0A=20=20=20=20=20=20=20=
column=20is=20not=20a=20generated=20column,=20no=20error=20is=20thrown.=20=
=20In=20this=20case=20a=0A=20=20=20=20=20=20=20notice=20is=20issued=20=
instead.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=
=20=20=20When=20applied=20to=20a=20partitioned=20table,=20the=20=
generation=20expression=20is=0A+=20=20=20=20=20=20dropped=20from=20the=20=
partitioned=20table=20definition=20and=20from=20all=0A+=20=20=20=20=20=20=
partitions.=20Specifying=20<literal>ONLY</literal>=20is=20not=20allowed,=20=
and=0A+=20=20=20=20=20=20this=20command=20cannot=20be=20used=20on=20=
individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-327,12=20+361,17=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20and=20<command>UPDATE</command>=20commands;=20they=20do=20not=20=
cause=20rows=0A=20=20=20=20=20=20=20already=20in=20the=20table=20to=20=
change.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=
=20=20=20=20=20If=20<literal>DROP=20IDENTITY=20IF=20EXISTS</literal>=20=
is=20specified=20and=20the=0A=20=20=20=20=20=20=20column=20is=20not=20an=20=
identity=20column,=20no=20error=20is=20thrown.=20=20In=20this=20case=20a=0A=
=20=20=20=20=20=20=20notice=20is=20issued=20instead.=0A=20=20=20=20=20=20=
</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20applied=20=
to=20a=20partitioned=20table,=20the=20identity=20property=20is=20defined=0A=
+=20=20=20=20=20=20on=20the=20partitioned=20table=20and=20is=20applied=20=
to=20all=20partitions.=0A+=20=20=20=20=20=20Specifying=20=
<literal>ONLY</literal>=20is=20not=20allowed,=20and=20these=20forms=0A+=20=
=20=20=20=20=20cannot=20be=20used=20on=20individual=20partitions.=0A+=20=20=
=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20=
</varlistentry>=0A=20=0A@@=20-346,6=20+385,13=20@@=20WITH=20(=20MODULUS=20=
<replaceable=20class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=
=20=20=20=20=20=20=20supported=20by=20<link=20=
linkend=3D"sql-altersequence"><command>ALTER=20SEQUENCE</command></link>=20=
such=0A=20=20=20=20=20=20=20as=20<literal>INCREMENT=20BY</literal>.=0A=20=
=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=
When=20applied=20to=20a=20partitioned=20table,=20these=20forms=20alter=20=
the=20sequence=0A+=20=20=20=20=20=20associated=20with=20the=20identity=20=
column=20on=20the=20partitioned=20table=0A+=20=20=20=20=20=20and=20all=20=
individual=20partitions.=20Specifying=20<literal>ONLY</literal>=0A+=20=20=
=20=20=20=20is=20not=20allowed,=20and=20these=20forms=20cannot=20be=20=
used=20on=20individual=0A+=20=20=20=20=20=20partitions.=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
@@=20-369,6=20+415,10=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20<literal>SET=20STATISTICS</literal>=20acquires=20a=0A=20=20=20=20=20=
=20=20<literal>SHARE=20UPDATE=20EXCLUSIVE</literal>=20lock.=0A=20=20=20=20=
=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20For=20=
partitioned=20tables,=20this=20action=20applies=20to=20the=20partitioned=20=
table=0A+=20=20=20=20=20=20and=20all=20of=20its=20partitions=20unless=20=
<literal>ONLY</literal>=20is=20specified.=0A+=20=20=20=20=20</para>=0A=20=
=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20=
-403,6=20+453,11=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20Changing=20per-attribute=20options=20acquires=20a=0A=20=20=20=20=20=
=20=20<literal>SHARE=20UPDATE=20EXCLUSIVE</literal>=20lock.=0A=20=20=20=20=
=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20=
applied=20to=20a=20partitioned=20table=20<literal>ONLY</literal>=20is=20=
implicit,=0A+=20=20=20=20=20=20these=20forms=20must=20be=20applied=20=
separately=20to=20the=20partitioned=20table=20and/or=20to=0A+=20=20=20=20=
=20=20individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-437,6=20+492,10=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20during=20future=20table=20updates.=0A=20=20=20=20=20=20=20See=20=
<xref=20linkend=3D"storage-toast"/>=20for=20more=20information.=0A=20=20=20=
=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20=
applied=20to=20a=20partitioned=20table,=20the=20storage=20setting=20is=20=
propagated=0A+=20=20=20=20=20=20to=20all=20existing=20partitions=20=
unless=20<literal>ONLY</literal>=20is=20specified.=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
@@=20-467,6=20+526,11=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20consulting=20the=20<xref=20=
linkend=3D"guc-default-toast-compression"/>=20setting=0A=20=20=20=20=20=20=
=20at=20the=20time=20of=20data=20insertion=20to=20determine=20the=20=
method=20to=20use.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A=
+=20=20=20=20=20=20When=20applied=20to=20a=20partitioned=20table=20=
<literal>ONLY</literal>=20is=20implicit,=0A+=20=20=20=20=20=20the=20=
compression=20method=20must=20be=20applied=20separately=20to=20the=20=
partitioned=20table=0A+=20=20=20=20=20=20and/or=20to=20individual=20=
partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=
=20=20</varlistentry>=0A=20=0A@@=20-479,7=20+543,6=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20VALID</literal>,=20which=20is=20currently=20only=20allowed=20for=20=
foreign-key,=0A=20=20=20=20=20=20=20<literal>CHECK</literal>,=20and=20=
not-null=20constraints.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=
=20<para>=0A=20=20=20=20=20=20=20Normally,=20this=20form=20will=20cause=20=
a=20scan=20of=20the=20table=20to=20verify=20that=20all=0A=20=20=20=20=20=20=
=20existing=20rows=20in=20the=20table=20satisfy=20the=20new=20=
constraint.=20=20But=20if=0A@@=20-495,7=20+558,6=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20See=20<xref=20linkend=3D"sql-altertable-notes"/>=20below=20for=20=
more=20information=0A=20=20=20=20=20=20=20about=20using=20the=20=
<literal>NOT=20VALID</literal>=20option.=0A=20=20=20=20=20=20</para>=0A-=0A=
=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20Although=20most=20forms=20=
of=20<literal>ADD=0A=20=20=20=20=20=20=20<replaceable=20=
class=3D"parameter">table_constraint</replaceable></literal>=0A@@=20=
-506,12=20+568,19=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20referenced=20table,=20in=20addition=20to=20the=20lock=20on=20the=20=
table=20on=20which=20the=0A=20=20=20=20=20=20=20constraint=20is=20=
declared.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=
=20=20=20=20=20=20Additional=20restrictions=20apply=20when=20unique=20or=20=
primary=20key=20constraints=0A=20=20=20=20=20=20=20are=20added=20to=20=
partitioned=20tables;=20see=20<link=20=
linkend=3D"sql-createtable"><command>CREATE=20TABLE</command></link>.=0A=20=
=20=20=20=20=20</para>=0A-=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=
When=20applied=20to=20a=20partitioned=20table,=20the=20constraint=20is=20=
added=20to=20the=0A+=20=20=20=20=20=20partitioned=20table=20and=20is=20=
implicitly=20added=20to=20all=20partitions.=0A+=20=20=20=20=20=20=
Specifying=20<literal>ONLY</literal>=20is=20not=20allowed.=0A+=20=20=20=20=
=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20For=20=
inheritance=20setups,=20the=20constraint=20is=20not=20added=20to=20child=20=
tables=20unless=20it=20is=0A+=20=20=20=20=20=20a=20=
<literal>CHECK</literal>=20constraint=20that=20is=20inheritable=20(that=20=
is,=20not=20declared=20<literal>NO=20INHERIT</literal>).=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
@@=20-523,7=20+592,6=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20constraint=20to=20a=20table=20based=20on=20an=20existing=20unique=20=
index.=20=20All=20the=0A=20=20=20=20=20=20=20columns=20of=20the=20index=20=
will=20be=20included=20in=20the=20constraint.=0A=20=20=20=20=20=20=
</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20The=20=
index=20cannot=20have=20expression=20columns=20nor=20be=20a=20partial=20=
index.=0A=20=20=20=20=20=20=20Also,=20it=20must=20be=20a=20b-tree=20=
index=20with=20default=20sort=20ordering.=20=20These=0A@@=20-531,7=20=
+599,6=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20built=20by=20a=20regular=20<literal>ADD=20PRIMARY=20KEY</literal>=20=
or=20<literal>ADD=20UNIQUE</literal>=0A=20=20=20=20=20=20=20command.=0A=20=
=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=
=20If=20<literal>PRIMARY=20KEY</literal>=20is=20specified,=20and=20the=20=
index's=20columns=20are=20not=0A=20=20=20=20=20=20=20already=20marked=20=
<literal>NOT=20NULL</literal>,=20then=20this=20command=20will=20attempt=20=
to=0A@@=20-539,13=20+606,11=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20That=20requires=20a=20full=20table=20scan=20to=20verify=20the=20=
column(s)=20contain=20no=0A=20=20=20=20=20=20=20nulls.=20=20In=20all=20=
other=20cases,=20this=20is=20a=20fast=20operation.=0A=20=20=20=20=20=20=
</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20If=20a=20=
constraint=20name=20is=20provided=20then=20the=20index=20will=20be=20=
renamed=20to=20match=0A=20=20=20=20=20=20=20the=20constraint=20name.=20=20=
Otherwise=20the=20constraint=20will=20be=20named=20the=20same=20as=0A=20=20=
=20=20=20=20=20the=20index.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=
=20=20<para>=0A=20=20=20=20=20=20=20After=20this=20command=20is=20=
executed,=20the=20index=20is=20<quote>owned</quote>=20by=20the=0A=20=20=20=
=20=20=20=20constraint,=20in=20the=20same=20way=20as=20if=20the=20index=20=
had=20been=20built=20by=0A@@=20-553,11=20+618,10=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20command.=20=20In=20particular,=20dropping=20the=20constraint=20=
will=20make=20the=20index=0A=20=20=20=20=20=20=20disappear=20too.=0A=20=20=
=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A-=20=20=20=20=20=20=
This=20form=20is=20not=20currently=20supported=20on=20partitioned=20=
tables.=0A+=20=20=20=20=20=20This=20form=20is=20not=20supported=20on=20=
partitioned=20tables,=20but=20can=20be=20used=20on=0A+=20=20=20=20=20=20=
individual=20partitions.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=
=20<note>=0A=20=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20=20Adding=20=
a=20constraint=20using=20an=20existing=20index=20can=20be=20helpful=20in=0A=
@@=20-578,6=20+642,12=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20created.=20Currently=20only=20foreign=20key=20constraints=20may=20=
be=20altered=20in=0A=20=20=20=20=20=20=20this=20fashion,=20but=20see=20=
below.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=
=20=20When=20applied=20to=20a=20partitioned=20table,=20the=20constraint=20=
is=20altered=20on=20the=0A+=20=20=20=20=20=20partitioned=20table=20=
definition=20and=20implicitly=20applied=20to=20all=20partitions.=0A+=20=20=
=20=20=20=20Specifying=20<literal>ONLY</literal>=20is=20not=20allowed,=20=
and=20this=20command=0A+=20=20=20=20=20=20cannot=20be=20used=20on=20=
individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-596,7=20+666,11=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20non-inheritable=20on=20a=20table=20with=20children,=20then=20the=20=
corresponding=0A=20=20=20=20=20=20=20constraint=20on=20children=20will=20=
be=20marked=20as=20no=20longer=20inherited,=0A=20=20=20=20=20=20=20but=20=
not=20removed.=0A-=20=20=20=20=20=20</para>=0A+=20=20=20=20=20</para>=0A=
+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20These=20forms=20are=20not=20=
supported=20on=20partitioned=20tables,=20but=20can=20be=20used=0A+=20=20=20=
=20=20=20on=20individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=
=20=20=20=20</listitem>=0A=20=20=20=20=20</varlistentry>=0A=20=0A@@=20=
-615,6=20+689,13=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20<para>=0A=20=20=20=20=20=20=20This=20command=20acquires=20a=20=
<literal>SHARE=20UPDATE=20EXCLUSIVE</literal>=20lock.=0A=20=20=20=20=20=20=
</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20applied=20=
to=20a=20partitioned=20table,=20the=20constraint=20is=20validated=20on=20=
the=0A+=20=20=20=20=20=20partitioned=20table=20and=20on=20all=20=
partitions.=20Unlike=20most=20constraint-related=0A+=20=20=20=20=20=20=
sub-commands,=20individual=20partitions=20may=20validate=20the=20=
constraint=0A+=20=20=20=20=20=20independently=20of=20the=20partitioned=20=
table,=20so=20long=20as=20the=20partitioned=0A+=20=20=20=20=20=20table=20=
itself=20is=20not=20yet=20validated.=0A+=20=20=20=20=20</para>=0A=20=20=20=
=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-627,6=20=
+708,11=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20If=20<literal>IF=20EXISTS</literal>=20is=20specified=20and=20the=20=
constraint=0A=20=20=20=20=20=20=20does=20not=20exist,=20no=20error=20is=20=
thrown.=20In=20this=20case=20a=20notice=20is=20issued=20instead.=0A=20=20=
=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20=
applied=20to=20a=20partitioned=20table,=20the=20constraint=20is=20=
dropped=20from=0A+=20=20=20=20=20=20all=20existing=20partitions=20unless=20=
<literal>ONLY</literal>=20is=20specified.=0A+=20=20=20=20=20=20Dropping=20=
an=20inherited=20constaint=20from=20an=20individual=20partition=20is=20=
not=20allowed.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=
=20=20=20</varlistentry>=0A=20=0A@@=20-648,7=20+734,6=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20of=20course=20the=20integrity=20of=20the=20constraint=20cannot=20=
be=20guaranteed=20if=20the=0A=20=20=20=20=20=20=20triggers=20are=20not=20=
executed.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=
=20=20=20=20=20=20The=20trigger=20firing=20mechanism=20is=20also=20=
affected=20by=20the=20configuration=0A=20=20=20=20=20=20=20variable=20=
<xref=20linkend=3D"guc-session-replication-role"/>.=20Simply=20enabled=0A=
@@=20-658,7=20+743,6=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20mode,=20and=20triggers=20configured=20as=20<literal>ENABLE=20=
ALWAYS</literal>=20will=0A=20=20=20=20=20=20=20fire=20regardless=20of=20=
the=20current=20replication=20role.=0A=20=20=20=20=20=20</para>=0A-=0A=20=
=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20The=20effect=20of=20this=20=
mechanism=20is=20that=20in=20the=20default=20configuration,=0A=20=20=20=20=
=20=20=20triggers=20do=20not=20fire=20on=20replicas.=20=20This=20is=20=
useful=20because=20if=20a=20trigger=0A@@=20-670,13=20+754,15=20@@=20WITH=20=
(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20to=20<literal>ENABLE=20ALWAYS</literal>=20so=20that=20it=20is=20=
also=20fired=20on=0A=20=20=20=20=20=20=20replicas.=0A=20=20=20=20=20=20=
</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20When=20=
this=20command=20is=20applied=20to=20a=20partitioned=20table,=20the=20=
states=20of=0A-=20=20=20=20=20=20corresponding=20clone=20triggers=20in=20=
the=20partitions=20are=20updated=20too,=0A-=20=20=20=20=20=20unless=20=
<literal>ONLY</literal>=20is=20specified.=0A+=20=20=20=20=20=20=
corresponding=20clone=20triggers=20are=20updated=20too,=20unless=20=
<literal>ONLY</literal>=0A+=20=20=20=20=20=20is=20specified.=0A+=20=20=20=
=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20For=20=
inheritance=20setups=20<literal>ONLY</literal>=20is=20implied,=20though=20=
it=20may=0A+=20=20=20=20=20=20be=20specified.=0A=20=20=20=20=20=20=
</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20This=20=
command=20acquires=20a=20<literal>SHARE=20ROW=20EXCLUSIVE</literal>=20=
lock.=0A=20=20=20=20=20=20</para>=0A@@=20-694,12=20+780,16=20@@=20WITH=20=
(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20are=20always=20applied=20in=20order=20to=20keep=20views=20working=20=
even=20if=20the=20current=0A=20=20=20=20=20=20=20session=20is=20in=20a=20=
non-default=20replication=20role.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=
=20=20=20=20<para>=0A=20=20=20=20=20=20=20The=20rule=20firing=20=
mechanism=20is=20also=20affected=20by=20the=20configuration=20variable=0A=
=20=20=20=20=20=20=20<xref=20linkend=3D"guc-session-replication-role"/>,=20=
analogous=20to=20triggers=20as=0A=20=20=20=20=20=20=20described=20above.=0A=
=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=
When=20applied=20to=20a=20partitioned=20table=20<literal>ONLY</literal>=20=
is=20implicit,=0A+=20=20=20=20=20=20these=20forms=20must=20be=20applied=20=
separately=20to=20the=20partitioned=20table=0A+=20=20=20=20=20=20and/or=20=
to=20individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-715,6=20+805,11=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20See=20also=0A=20=20=20=20=20=20=20<link=20=
linkend=3D"sql-createpolicy"><command>CREATE=20POLICY</command></link>.=0A=
=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=
When=20applied=20to=20a=20partitioned=20table=20<literal>ONLY</literal>=20=
is=20implicit,=0A+=20=20=20=20=20=20these=20forms=20must=20be=20applied=20=
separately=20to=20the=20partitioned=20table=20and/or=20to=0A+=20=20=20=20=
=20=20individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-730,6=20+825,11=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20See=20also=0A=20=20=20=20=20=20=20<link=20=
linkend=3D"sql-createpolicy"><command>CREATE=20POLICY</command></link>.=0A=
=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=
When=20applied=20to=20a=20partitioned=20table=20<literal>ONLY</literal>=20=
is=20implicit,=0A+=20=20=20=20=20=20this=20form=20must=20be=20applied=20=
separately=20to=20the=20partitioned=20table=20and/or=20to=0A+=20=20=20=20=
=20=20individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-744,6=20+844,10=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20<para>=0A=20=20=20=20=20=20=20Changing=20cluster=20options=20acquires=20=
a=20<literal>SHARE=20UPDATE=20EXCLUSIVE</literal>=20lock.=0A=20=20=20=20=20=
=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20This=20form=20=
is=20not=20supported=20on=20partitioned=20tables,=20but=20can=20be=20=
used=20on=0A+=20=20=20=20=20=20individual=20partitions.=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
@@=20-759,6=20+863,10=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20<para>=0A=20=20=20=20=20=20=20Changing=20cluster=20options=20acquires=20=
a=20<literal>SHARE=20UPDATE=20EXCLUSIVE</literal>=20lock.=0A=20=20=20=20=20=
=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20This=20form=20=
is=20not=20supported=20on=20partitioned=20tables,=20but=20can=20be=20=
used=20on=0A+=20=20=20=20=20=20individual=20partitions.=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
@@=20-786,11=20+894,10=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20</para>=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20When=20=
applied=20to=20a=20partitioned=20table,=20there=20is=20no=20data=20to=20=
rewrite,=0A-=20=20=20=20=20=20but=20partitions=20created=20afterwards=20=
will=20default=20to=20the=20given=20access=0A-=20=20=20=20=20=20method=20=
unless=20overridden=20by=20a=20<literal>USING</literal>=20clause.=0A-=20=20=
=20=20=20=20Specifying=20<varname>DEFAULT</varname>=20removes=20a=20=
previous=20value,=0A-=20=20=20=20=20=20causing=20future=20partitions=20=
to=20default=20to=0A-=20=20=20=20=20=20=
<varname>default_table_access_method</varname>.=0A+=20=20=20=20=20=20=
only=20the=20default=20for=20newly=20created=20partitions=20is=20=
changed.=0A+=20=20=20=20=20=20Specifying=20<literal>DEFAULT</literal>=20=
removes=20a=20previously=20set=20access=20method,=0A+=20=20=20=20=20=20=
causing=20future=20partitions=20to=20use=20=
<varname>default_table_access_method</varname>.=0A+=20=20=20=20=20=20=
Individual=20partitions=20are=20affected=20just=20like=20any=20other=20=
regular=20table.=0A=20=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A@@=20-803,12=20+910,9=20@@=20=
WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20moves=20the=20data=20file(s)=20associated=20with=20the=20table=20=
to=20the=20new=20tablespace.=0A=20=20=20=20=20=20=20Indexes=20on=20the=20=
table,=20if=20any,=20are=20not=20moved;=20but=20they=20can=20be=20moved=0A=
=20=20=20=20=20=20=20separately=20with=20additional=20<literal>SET=20=
TABLESPACE</literal>=20commands.=0A-=20=20=20=20=20=20When=20applied=20=
to=20a=20partitioned=20table,=20nothing=20is=20moved,=20but=20any=0A-=20=20=
=20=20=20=20partitions=20created=20afterwards=20with=0A-=20=20=20=20=20=20=
<command>CREATE=20TABLE=20PARTITION=20OF</command>=20will=20use=20that=20=
tablespace,=0A-=20=20=20=20=20=20unless=20overridden=20by=20a=20=
<literal>TABLESPACE</literal>=20clause.=0A+=20=20=20=20=20=20When=20=
applied=20to=20a=20partitioned=20table,=20no=20data=20is=20moved,=20only=20=
the=20default=0A+=20=20=20=20=20=20for=20newly=20created=20partitions=20=
is=20changed.=0A=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=
=20=20=20=20=20=20=20All=20tables=20in=20the=20current=20database=20in=20=
a=20tablespace=20can=20be=20moved=20by=20using=0A=20=20=20=20=20=20=20=
the=20<literal>ALL=20IN=20TABLESPACE</literal>=20form,=20which=20will=20=
lock=20all=20tables=0A@@=20-835,15=20+939,14=20@@=20WITH=20(=20MODULUS=20=
<replaceable=20class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=
=20=20=20=20=20=20=20(see=20<xref=20=
linkend=3D"sql-createtable-unlogged"/>).=20=20It=20cannot=20be=20applied=0A=
=20=20=20=20=20=20=20to=20a=20temporary=20table.=0A=20=20=20=20=20=20=
</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20This=20=
also=20changes=20the=20persistence=20of=20any=20sequences=20linked=20to=20=
the=20table=0A=20=20=20=20=20=20=20(for=20identity=20or=20serial=20=
columns).=20=20However,=20it=20is=20also=20possible=20to=0A=20=20=20=20=20=
=20=20change=20the=20persistence=20of=20such=20sequences=20separately.=0A=
=20=20=20=20=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A-=20=20=20=20=20=
=20This=20form=20is=20not=20supported=20for=20partitioned=20tables.=0A+=20=
=20=20=20=20=20This=20form=20is=20not=20supported=20on=20partitioned=20=
tables,=20but=20can=20be=20used=20on=0A+=20=20=20=20=20=20individual=20=
partitions.=0A=20=20=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=
=20=20=20</varlistentry>=0A@@=20-865,12=20+968,15=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20time=20the=20table=20is=20locked=20so=20currently=20executing=20=
queries=20will=20not=20be=0A=20=20=20=20=20=20=20affected.=0A=20=20=20=20=
=20=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20=
<literal>SHARE=20UPDATE=20EXCLUSIVE</literal>=20lock=20will=20be=20taken=20=
for=0A=20=20=20=20=20=20=20fillfactor,=20TOAST=20and=20autovacuum=20=
storage=20parameters,=20as=20well=20as=20the=0A=20=20=20=20=20=20=20=
planner=20parameter=20<varname>parallel_workers</varname>.=0A=20=20=20=20=
=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20This=20form=20=
is=20not=20supported=20on=20partitioned=20tables,=20but=20can=20be=20=
used=20on=0A+=20=20=20=20=20=20individual=20partitions.=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
@@=20-882,6=20+988,11=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20defaults.=20=20As=20with=20<literal>SET</literal>,=20a=20table=20=
rewrite=20might=20be=0A=20=20=20=20=20=20=20needed=20to=20update=20the=20=
table=20entirely.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A=
+=20=20=20=20=20=20When=20applied=20to=20a=20partitioned=20table,=20this=20=
form=20is=20accepted=20but=20has=20no=0A+=20=20=20=20=20=20practical=20=
effect.=20=20It=20can=20be=20used=20on=20individual=20partitions,=20=
where=20it=0A+=20=20=20=20=20=20behaves=20as=20for=20a=20regular=20=
table.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=
=20</varlistentry>=0A=20=0A@@=20-895,7=20+1006,6=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20already=20contain=20all=20the=20same=20columns=20as=20the=20parent=20=
(it=20could=20have=0A=20=20=20=20=20=20=20additional=20columns,=20too).=20=
=20The=20columns=20must=20have=20matching=20data=20types.=0A=20=20=20=20=20=
=20</para>=0A-=0A=20=20=20=20=20=20<para>=0A=20=20=20=20=20=20=20In=20=
addition,=20all=20<literal>CHECK</literal>=20and=20<literal>NOT=20=
NULL</literal>=0A=20=20=20=20=20=20=20constraints=20on=20the=20parent=20=
must=20also=20exist=20on=20the=20child,=20except=20those=0A@@=20-907,6=20=
+1017,10=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20<literal>FOREIGN=20KEY</literal>=20constraints=20are=20not=20=
considered,=20but=0A=20=20=20=20=20=20=20this=20might=20change=20in=20=
the=20future.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=
=20=20=20=20=20This=20form=20does=20not=20support=20partitioned=20=
tables;=20it=20cannot=20be=20applied=20to=0A+=20=20=20=20=20=20either=20=
a=20partitioned=20table=20or=20its=20partitions.=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
@@=20-919,6=20+1033,10=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20Queries=20against=20the=20parent=20table=20will=20no=20longer=20=
include=20records=20drawn=0A=20=20=20=20=20=20=20from=20the=20target=20=
table.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=
=20=20This=20form=20does=20not=20support=20partitioned=20tables;=20it=20=
cannot=20be=20applied=20to=0A+=20=20=20=20=20=20either=20a=20partitioned=20=
table=20or=20its=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-933,6=20+1051,10=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20that=20<command>CREATE=20TABLE=20OF</command>=20would=20permit=20=
an=20equivalent=20table=0A=20=20=20=20=20=20=20definition.=0A=20=20=20=20=
=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20=
applied=20to=20a=20partitioned=20table=20<literal>ONLY</literal>=20is=20=
implicit,=0A+=20=20=20=20=20=20and=20this=20form=20cannot=20be=20used=20=
on=20individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20=
</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-942,6=20+1064,10=20=
@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20<para>=0A=20=20=20=20=20=20=20This=20form=20dissociates=20a=20typed=20=
table=20from=20its=20type.=0A=20=20=20=20=20=20</para>=0A+=20=20=20=20=20=
<para>=0A+=20=20=20=20=20=20When=20applied=20to=20a=20partitioned=20=
table=20<literal>ONLY</literal>=20is=20implicit,=0A+=20=20=20=20=20=20=
and=20this=20form=20cannot=20be=20used=20on=20individual=20partitions.=0A=
+=20=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20=
</varlistentry>=0A=20=0A@@=20-952,6=20+1078,11=20@@=20WITH=20(=20MODULUS=20=
<replaceable=20class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=
=20=20=20=20=20=20=20This=20form=20changes=20the=20owner=20of=20the=20=
table,=20sequence,=20view,=20materialized=20view,=0A=20=20=20=20=20=20=20=
or=20foreign=20table=20to=20the=20specified=20user.=0A=20=20=20=20=20=20=
</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20applied=20=
to=20a=20partitioned=20table=20<literal>ONLY</literal>=20is=20implicit,=0A=
+=20=20=20=20=20=20this=20form=20must=20be=20applied=20separately=20to=20=
the=20partitioned=20table=20and/or=20to=0A+=20=20=20=20=20=20individual=20=
partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=
=20=20</varlistentry>=0A=20=0A@@=20-1008,6=20+1139,12=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20=20</listitem>=0A=20=20=20=20=20=20=20</varlistentry>=0A=20=20=20=20=
=20=20</variablelist></para>=0A+=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=
=20=20When=20applied=20to=20a=20partitioned=20table=20=
<literal>ONLY</literal>=20is=20implicit,=0A+=20=20=20=20=20=20this=20=
form=20must=20be=20applied=20independently=20to=20the=20partitioned=20=
table=20and/or=0A+=20=20=20=20=20=20to=20individual=20partitions.=0A+=20=20=
=20=20=20</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20=
</varlistentry>=0A=20=0A@@=20-1022,6=20+1159,17=20@@=20WITH=20(=20=
MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20the=20index=20is=20renamed=20as=20well.=0A=20=20=20=20=20=20=20=
There=20is=20no=20effect=20on=20the=20stored=20data.=0A=20=20=20=20=20=20=
</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20When=20applied=20=
to=20a=20partitioned=20table,=20partition=20columns=20and=20constraints=0A=
+=20=20=20=20=20=20are=20implicitly=20renamed=20and=20=
<literal>ONLY</literal>=20is=20implied,=20though=0A+=20=20=20=20=20=20it=20=
may=20be=20specified.=0A+=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A=
+=20=20=20=20=20=20For=20inheritance=20setups,=20the=20behavior=20=
described=20for=20partitioned=20tables=20applies=0A+=20=20=20=20=20=20=
only=20to=20the=20dependent=20column(s)=20on=20the=20descendant=20=
table(s).=20=20It=20is=20always=0A+=20=20=20=20=20=20allowed=20to=20=
target=20a=20descendant=20table=20with=20column=20altering=20commands=20=
on=20independent=0A+=20=20=20=20=20=20columns.=0A+=20=20=20=20=20</para>=0A=
=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20=
-1032,6=20+1180,11=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20This=20form=20moves=20the=20table=20into=20another=20schema.=20=20=
Associated=20indexes,=0A=20=20=20=20=20=20=20constraints,=20and=20=
sequences=20owned=20by=20table=20columns=20are=20moved=20as=20well.=0A=20=
=20=20=20=20=20</para>=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=
When=20applied=20to=20a=20partitioned=20table=20<literal>ONLY</literal>=20=
is=20implicit,=0A+=20=20=20=20=20=20this=20form=20must=20be=20applied=20=
independently=20to=20the=20partitioned=20table=20and/or=0A+=20=20=20=20=20=
=20to=20individual=20partitions.=0A+=20=20=20=20=20</para>=0A=20=20=20=20=
=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A@@=20-1410,6=20=
+1563,27=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20=20=20<literal>*</literal>=20can=20be=20specified=20after=20the=20=
table=20name=20to=20explicitly=0A=20=20=20=20=20=20=20=20=20indicate=20=
that=20descendant=20tables=20are=20included.=0A=20=20=20=20=20=20=20=20=
</para>=0A+=0A+=20=20=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=20=20=
For=20a=20table=20that=20uses=20table=20inheritance,=20descendant=20=
tables=20are=20those=0A+=20=20=20=20=20=20=20=20that=20inherit=20from=20=
the=20named=20table,=20directly=20or=20indirectly.=0A+=20=20=20=20=20=20=20=
=20For=20a=20partitioned=20table,=20descendant=20tables=20are=20its=20=
partitions.=0A+=20=20=20=20=20=20=20</para>=0A+=0A+=20=20=20=20=20=20=20=
<para>=0A+=20=20=20=20=20=20=20=20Note=20that=20for=20partitioned=20=
tables,=20<literal>ONLY</literal>=20does=20not=20control=0A+=20=20=20=20=20=
=20=20=20recursion=20for=20all=20<command>ALTER=20TABLE</command>=20=
actions.=20Some=20actions=0A+=20=20=20=20=20=20=20=20apply=20only=20to=20=
the=20partitioned=20table=20itself,=20regardless=20of=20whether=0A+=20=20=
=20=20=20=20=20=20<literal>ONLY</literal>=20is=20specified,=20while=20=
others=20are=20propagated=20to=0A+=20=20=20=20=20=20=20=20partitions.=20=
The=20exact=20behavior=20depends=20on=20the=20specific=20action=20being=0A=
+=20=20=20=20=20=20=20=20performed.=0A+=20=20=20=20=20=20=20</para>=0A+=0A=
+=20=20=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=20=20Users=20should=20=
consult=20the=20documentation=20of=20each=20individual=0A+=20=20=20=20=20=
=20=20=20<command>ALTER=20TABLE</command>=20action=20to=20determine=20=
whether=20and=20how=20it=0A+=20=20=20=20=20=20=20=20affects=20=
partitions.=0A+=20=20=20=20=20=20=20</para>=0A=20=20=20=20=20=20=20=
</listitem>=0A=20=20=20=20=20=20</varlistentry>=0A=20=0A@@=20-1768,45=20=
+1942,10=20@@=20WITH=20(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=
</para>=0A=20=0A=20=20=20=20<para>=0A-=20=20=20=20If=20a=20table=20has=20=
any=20descendant=20tables,=20it=20is=20not=20permitted=20to=20add,=0A-=20=
=20=20=20rename,=20or=20change=20the=20type=20of=20a=20column=20in=20the=20=
parent=20table=20without=20doing=0A-=20=20=20=20the=20same=20to=20the=20=
descendants.=20=20This=20ensures=20that=20the=20descendants=20always=0A-=20=
=20=20=20have=20columns=20matching=20the=20parent.=20=20Similarly,=20a=20=
<literal>CHECK</literal>=0A-=20=20=20=20constraint=20cannot=20be=20=
renamed=20in=20the=20parent=20without=20also=20renaming=20it=20in=0A-=20=20=
=20=20all=20descendants,=20so=20that=20<literal>CHECK</literal>=20=
constraints=20also=20match=0A-=20=20=20=20between=20the=20parent=20and=20=
its=20descendants.=20=20(That=20restriction=20does=20not=20apply=0A-=20=20=
=20=20to=20index-based=20constraints,=20however.)=0A-=20=20=20=20Also,=20=
because=20selecting=20from=20the=20parent=20also=20selects=20from=20its=20=
descendants,=0A-=20=20=20=20a=20constraint=20on=20the=20parent=20cannot=20=
be=20marked=20valid=20unless=20it=20is=20also=20marked=0A-=20=20=20=20=
valid=20for=20those=20descendants.=20=20In=20all=20of=20these=20cases,=20=
<command>ALTER=20TABLE=0A-=20=20=20=20ONLY</command>=20will=20be=20=
rejected.=0A-=20=20=20</para>=0A-=0A-=20=20=20<para>=0A-=20=20=20=20A=20=
recursive=20<literal>DROP=20COLUMN</literal>=20operation=20will=20remove=20=
a=0A-=20=20=20=20descendant=20table's=20column=20only=20if=20the=20=
descendant=20does=20not=20inherit=0A-=20=20=20=20that=20column=20from=20=
any=20other=20parents=20and=20never=20had=20an=20independent=0A-=20=20=20=
=20definition=20of=20the=20column.=20=20A=20nonrecursive=20<literal>DROP=0A=
-=20=20=20=20COLUMN</literal>=20(i.e.,=20<command>ALTER=20TABLE=20ONLY=20=
...=20DROP=0A-=20=20=20=20COLUMN</command>)=20never=20removes=20any=20=
descendant=20columns,=20but=0A-=20=20=20=20instead=20marks=20them=20as=20=
independently=20defined=20rather=20than=20inherited.=0A-=20=20=20=20A=20=
nonrecursive=20<literal>DROP=20COLUMN</literal>=20command=20will=20fail=20=
for=20a=0A-=20=20=20=20partitioned=20table,=20because=20all=20partitions=20=
of=20a=20table=20must=20have=20the=20same=0A-=20=20=20=20columns=20as=20=
the=20partitioning=20root.=0A-=20=20=20</para>=0A-=0A-=20=20=20<para>=0A=
-=20=20=20=20The=20actions=20for=20identity=20columns=20(<literal>ADD=0A=
-=20=20=20=20GENERATED</literal>,=20<literal>SET</literal>=20etc.,=20=
<literal>DROP=0A-=20=20=20=20IDENTITY</literal>),=20as=20well=20as=20the=20=
actions=0A-=20=20=20=20<literal>CLUSTER</literal>,=20=
<literal>OWNER</literal>,=0A-=20=20=20=20and=20=
<literal>TABLESPACE</literal>=20never=20recurse=20to=20descendant=20=
tables;=0A-=20=20=20=20that=20is,=20they=20always=20act=20as=20though=20=
<literal>ONLY</literal>=20were=20specified.=0A-=20=20=20=20Actions=20=
affecting=20trigger=20states=20recurse=20to=20partitions=20of=20=
partitioned=0A-=20=20=20=20tables=20(unless=20<literal>ONLY</literal>=20=
is=20specified),=20but=20never=20to=0A-=20=20=20=20=
traditional-inheritance=20descendants.=0A-=20=20=20=20Adding=20a=20=
constraint=20recurses=20only=20for=20<literal>CHECK</literal>=20=
constraints=0A-=20=20=20=20that=20are=20not=20marked=20<literal>NO=20=
INHERIT</literal>.=0A+=20=20=20=20For=20inheritance=20setups,=20the=20=
behavior=20described=20for=20partitioned=20tables=20applies=0A+=20=20=20=20=
only=20to=20the=20dependent=20column(s)=20on=20the=20descendant=20=
table(s).=20=20It=20is=20always=0A+=20=20=20=20allowed=20to=20target=20a=20=
descendant=20table=20with=20column=20altering=20commands=20on=20=
independent=0A+=20=20=20=20columns.=0A=20=20=20=20</para>=0A=20=0A=20=20=20=
=20<para>=0Adiff=20--git=20a/doc/src/sgml/ref/create_table.sgml=20=
b/doc/src/sgml/ref/create_table.sgml=0Aindex=2077c5a763d45..2fcab0d874e=20=
100644=0A---=20a/doc/src/sgml/ref/create_table.sgml=0A+++=20=
b/doc/src/sgml/ref/create_table.sgml=0A@@=20-633,6=20+633,13=20@@=20WITH=20=
(=20MODULUS=20<replaceable=20=
class=3D"parameter">numeric_literal</replaceable>,=20REM=0A=20=20=20=20=20=
=20=20concurrent=20operations=20on=20the=20partitioned=20table.=0A=20=20=20=
=20=20=20</para>=0A=20=0A+=20=20=20=20=20<para>=0A+=20=20=20=20=20=20=
When=20a=20partition=20is=20created,=20it=20inherits=20many=20of=20the=20=
properties=0A+=20=20=20=20=20=20of=20the=20parent=20table.=20=20However,=20=
properties=20related=20to=20ownership,=0A+=20=20=20=20=20=20schema,=20=
replica=20identity,=20row-level=20security=20configuration,=0A+=20=20=20=20=
=20=20per-attribute=20statistics=20targets,=20and=20per-attribute=20=
options=0A+=20=20=20=20=20=20are=20not=20inherited.=0A+=20=20=20=20=20=
</para>=0A=20=20=20=20=20</listitem>=0A=20=20=20=20</varlistentry>=0A=20=0A=
--=20=0A2.50.1=20(Apple=20Git-155)=0A=0A=

--Apple-Mail=_A16E592C-84A0-4462-AED0-7D7DFC34EAC9
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=us-ascii


--Apple-Mail=_A16E592C-84A0-4462-AED0-7D7DFC34EAC9--