pgsql: Adjust comments of CheckRelationTableSpaceMove() and SetRelation - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Adjust comments of CheckRelationTableSpaceMove() and SetRelation
Date
Msg-id E1l5LvN-0002UO-MF@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Adjust comments of CheckRelationTableSpaceMove() and SetRelationTableSpace()

4c9c359, that introduced those two functions, has been overoptimistic on
the point that only ShareUpdateExclusiveLock would be required when
moving a relation to a new tablespace.  AccessExclusiveLock is a
requirement, but ShareUpdateExclusiveLock may be used under specific
conditions like REINDEX CONCURRENTLY where waits on past transactions
make the operation safe even with a lower-level lock.  The current code
does only the former, so update the existing comments to reflect that.

Once a REINDEX (TABLESPACE) is introduced, those comments would require
an extra refresh to mention their new use case.

While on it, fix an incorrect variable name.

Per discussion with Álvaro Herrera.

Discussion: https://postgr.es/m/20210127140741.GA14174@alvherre.pgsql

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/24843297a96d7be16cc3f4b090aacfc6e5e6839e

Modified Files
--------------
src/backend/commands/tablecmds.c | 13 ++++++-------
1 file changed, 6 insertions(+), 7 deletions(-)


pgsql-committers by date:

Previous
From: Thomas Munro
Date:
Subject: pgsql: Remove documentation of waiting restore_command.
Next
From: Michael Paquier
Date:
Subject: Re: pgsql: Refactor code in tablecmds.c to check and process tablespace mov