Horton

Alter all tables in schema owner fix

vignesh C <vignesh21@gmail.com>

View thread View on postgr.es
From: vignesh C <vignesh21@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Amit Kapila <amit.kapila16@gmail.com>, houzj.fnst@fujitsu.com
Date: 2021-12-03T03:06:23Z
Lists: pgsql-hackers

Attachments

Hi,

Currently while changing the owner of ALL TABLES IN SCHEMA
publication, it is not checked if the new owner has superuser
permission or not. Added a check to throw an error if the new owner
does not have superuser permission.
Attached patch has the changes for the same. Thoughts?

Regards,
Vignesh

Commits

  1. Fix changing the ownership of ALL TABLES IN SCHEMA publication.