diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-03-25 16:30:22 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-03-25 16:30:22 -0300 |
| commit | c8622999b7fe53741304f2aca73560aade6557d2 (patch) | |
| tree | aa99890f6c81959cfa19ca911e686994e5af1aa7 | |
| parent | a00c3068206e6daa236dbff0256cf3ad25ff5ed2 (diff) | |
Document lock obtained during partition detach
On partition detach, we acquire a SHARE lock on all tables that
reference the partitioned table that we're detaching a partition from,
but failed to document this fact. My oversight in commit f56f8f8da6af.
Repair. Backpatch to 12.
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Discussion: https://postgr.es/m/20210325180244.GA12738@alvherre.pgsql
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 9e6fcbcd111..609aeae2576 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -946,6 +946,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM ties to the table from which it was detached. Any indexes that were attached to the target table's indexes are detached. Any triggers that were created as clones of those in the target table are removed. + <literal>SHARE</literal> lock is obtained on any tables that reference + this partitioned table in foreign key constraints. </para> </listitem> </varlistentry> |