Why am I getting permission denied on an ownership change?
There are some unintuitive permissions requirements when using REASSIGN without a superuser.  See this other pots where I answered the same question: https://stackoverflow.com/a/62557497/79079