Commit3d4b143

committed

Document lock taken on referenced table when adding a foreign key

This can happen for CREATE TABLE and ALTER TABLE, so a mention is addedto both of them in the concerned subsections.Author: Adrien NayratDiscussion:https://postgr.es/m/c4e8af11-1dfc-766a-c953-76979b9fcdaa@anayrat.info

1 parent84f14fb commit3d4b143Copy full SHA for 3d4b143

File tree

-1

lines changed

-1

lines changed

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -372,6 +372,11 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`372`	`372`	`tables may not be declared <literal>NOT VALID</literal> at present.`
`373`	`373`	`</para>`
`374`	`374`
	`375`	`+ <para>`
	`376`	`+ The addition of a foreign key constraint requires a`
	`377`	`+ <literal>SHARE ROW EXCLUSIVE</literal> lock on the referenced table.`
	`378`	`+ </para>`
	`379`	`+`
`375`	`380`	`<para>`
`376`	`381`	`Additional restrictions apply when unique or primary key constraints`
`377`	`382`	`are added to partitioned tables; see <xref linkend="sql-createtable" />.`

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -934,7 +934,9 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`934`	`934`	`is used. The referenced columns must be the columns of a non-deferrable`
`935`	`935`	`unique or primary key constraint in the referenced table. The user`
`936`	`936`	`must have <literal>REFERENCES</literal> permission on the referenced table`
`937`		`- (either the whole table, or the specific referenced columns).`
	`937`	`+ (either the whole table, or the specific referenced columns). The`
	`938`	`+ addition of a foreign key constraint requires a`
	`939`	`+ <literal>SHARE ROW EXCLUSIVE</literal> lock on the referenced table.`
`938`	`940`	`Note that foreign key constraints cannot be defined between temporary`
`939`	`941`	`tables and permanent tables. Also note that while it is possible to`
`940`	`942`	`define a foreign key on a partitioned table, it is not possible to`

Comments

(0)