pgsql: Obtain required table lock during cross-table constraint updates

2025-06-29 Thread Tom Lane
Obtain required table lock during cross-table constraint updates. Sometimes a table's constraint may depend on a column of another table, so that we have to update the constraint when changing the referenced column's type. We need to have lock on the constraint's table to do that. ATPostAlterTyp

pgsql: Obtain required table lock during cross-table constraint updates

2025-06-29 Thread Tom Lane
Obtain required table lock during cross-table constraint updates. Sometimes a table's constraint may depend on a column of another table, so that we have to update the constraint when changing the referenced column's type. We need to have lock on the constraint's table to do that. ATPostAlterTyp

pgsql: Obtain required table lock during cross-table constraint updates

2025-06-29 Thread Tom Lane
Obtain required table lock during cross-table constraint updates. Sometimes a table's constraint may depend on a column of another table, so that we have to update the constraint when changing the referenced column's type. We need to have lock on the constraint's table to do that. ATPostAlterTyp

pgsql: Obtain required table lock during cross-table constraint updates

2025-06-29 Thread Tom Lane
Obtain required table lock during cross-table constraint updates. Sometimes a table's constraint may depend on a column of another table, so that we have to update the constraint when changing the referenced column's type. We need to have lock on the constraint's table to do that. ATPostAlterTyp

pgsql: Obtain required table lock during cross-table constraint updates

2025-06-29 Thread Tom Lane
Obtain required table lock during cross-table constraint updates. Sometimes a table's constraint may depend on a column of another table, so that we have to update the constraint when changing the referenced column's type. We need to have lock on the constraint's table to do that. ATPostAlterTyp

pgsql: Obtain required table lock during cross-table constraint updates

2025-06-29 Thread Tom Lane
Obtain required table lock during cross-table constraint updates. Sometimes a table's constraint may depend on a column of another table, so that we have to update the constraint when changing the referenced column's type. We need to have lock on the constraint's table to do that. ATPostAlterTyp