A database user is having all its objects into the public schema.
Now he requests to become the owner of the public schema to be able to do "reindex schema public".
I'm wondering if it is a good idea to change the ownership of the public schema?
Are there any possible side effects e.g. regarding extensions?
Thanks, Markus