DROP OWNED BY fails to drop the schemas on the workers

[onderkalaci]

CREATE USER u1 WITH superuser;
SELECT run_command_on_workers($$CREATE USER u1 WITH superuser;$$);
\c - u1 - 
create schema test_sc;

DROP OWNED BY u1;

create schema test_sc;
ERROR:  schema "test_sc" already exists
CONTEXT:  while executing command on localhost:9700

[TsinghuaLucky912]

#6519

[onurctirtir]

This doesn't seem to be fixed for all scenarios?:

create role non_super_user_role;
create schema my_schema;
alter schema my_schema owner to non_super_user_role ;
drop owned by non_super_user_role ;
create schema my_schema;
ERROR:  schema "my_schema" already exists
CONTEXT:  while executing command on localhost:9701

[marcocitus]

alter schema my_schema owner to non_super_user_role ;

seems like we're not propagating this one, so that's a different bug

[onurctirtir]

oh okay, so I should add this into #4812