]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Recurse to sequences on ownership change for all relkinds
authorPeter Eisentraut <peter_e@gmx.net>
Fri, 15 Jun 2018 03:22:14 +0000 (23:22 -0400)
committerPeter Eisentraut <peter_e@gmx.net>
Wed, 26 Sep 2018 18:20:59 +0000 (20:20 +0200)
commit992f8542a370d6885fc19e79e0fc46a1ebf902cb
tree47d4ec2ecc800fa3aa9cd7541ae508a098a6576e
parent69a5686368c9c5609fdb274714b39f7ded1b0b46
Recurse to sequences on ownership change for all relkinds

When a table ownership is changed, we must apply that also to any owned
sequences.  (Otherwise, it would result in a situation that cannot be
restored, because linked sequences must have the same owner as the
table.)  But this was previously only applied to regular tables and
materialized views.  But it should also apply to at least foreign
tables.  This patch removes the relkind check altogether, because it
doesn't save very much and just introduces the possibility of similar
omissions.

Bug: #15238
Reported-by: Christoph Berg <christoph.berg@credativ.de>
src/backend/commands/tablecmds.c