On 4/28/22 02:08, Dives, Chloe wrote:
> Thanks for your reply. I am using pg_upgrade to do the upgrade
In the Postgres 11 instance using psql what does:
\df+ bt_index_check
return.
In particular under the Access privileges column.
Also the output of:
\du
Going back to your original post, someone who is more familiar with
pg_upgrade maybe can explain:
Command was: SELECT pg_catalog.binary_upgrade_set_record_init_privs(true);
REVOKE ALL ON FUNCTION "public"."bt_index_check"("index" "regclass")
FROM PUBLIC;
REVOKE ALL ON FUNCTION "public"."bt_index_check"("index" "regclass")
FROM "rolename1";
SET SESSION AUTHORIZATION "16416";
GRANT ALL ON FUNCTION "public"."bt_index_check"("index" "regclass") TO
"16416";
RESET SESSION AUTHORIZATION;
SELECT pg_catalog.binary_upgrade_set_record_init_privs(false);
REVOKE ALL ON FUNCTION "public"."bt_index_check"("index" "regclass")
FROM "16416";
In other words why the role 16416 was GRANTed ALL then REVOKEd ALL on
the function?
--
Adrian Klaver
adrian.klaver@aklaver.com
