NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit6485469

committed

Recurse to sequences on ownership change for all relkinds

When a table ownership is changed, we must apply that also to any ownedsequences. (Otherwise, it would result in a situation that cannot berestored, because linked sequences must have the same owner as thetable.) But this was previously only applied to regular tables andmaterialized views. But it should also apply to at least foreigntables. This patch removes the relkind check altogether, because itdoesn't save very much and just introduces the possibility of similaromissions.Bug: #15238Reported-by: Christoph Berg <christoph.berg@credativ.de>

1 parent180feb8 commit6485469Copy full SHA for 6485469

File tree

1 file changed

-10

lines changed

src/backend/commands
- tablecmds.c

1 file changed

-10

lines changed

`‎src/backend/commands/tablecmds.c`

Lines changed: 6 additions & 10 deletions

Original file line number	Diff line number	Diff line change
`@@ -10446,17 +10446,13 @@ ATExecChangeOwner(Oid relationOid, Oid newOwnerId, bool recursing, LOCKMODE lock`
`10446`	`10446`	`list_free(index_oid_list);`
`10447`	`10447`	`}`
`10448`	`10448`
`10449`		`-if (tuple_class->relkind==RELKIND_RELATION\|\|`
`10450`		`-tuple_class->relkind==RELKIND_MATVIEW)`
`10451`		`-{`
`10452`		`-/* If it has a toast table, recurse to change its ownership */`
`10453`		`-if (tuple_class->reltoastrelid!=InvalidOid)`
`10454`		`-ATExecChangeOwner(tuple_class->reltoastrelid,newOwnerId,`
`10455`		`- true,lockmode);`
	`10449`	`+/* If it has a toast table, recurse to change its ownership */`
	`10450`	`+if (tuple_class->reltoastrelid!=InvalidOid)`
	`10451`	`+ATExecChangeOwner(tuple_class->reltoastrelid,newOwnerId,`
	`10452`	`+ true,lockmode);`
`10456`	`10453`
`10457`		`-/* If it has dependent sequences, recurse to change them too */`
`10458`		`-change_owner_recurse_to_sequences(relationOid,newOwnerId,lockmode);`
`10459`		`-}`
	`10454`	`+/* If it has dependent sequences, recurse to change them too */`
	`10455`	`+change_owner_recurse_to_sequences(relationOid,newOwnerId,lockmode);`
`10460`	`10456`	`}`
`10461`	`10457`
`10462`	`10458`	`InvokeObjectPostAlterHook(RelationRelationId,relationOid,0);`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit6485469

File tree

1 file changed

1 file changed

`‎src/backend/commands/tablecmds.c`

0 commit comments