Cannot change owner of crdb_internal_region

[electrum]

CREATE DATABASE foo PRIMARY REGION "us-east1";
ALTER TYPE foo.public.crdb_internal_region OWNER TO abc;

ERROR: "foo.public.crdb_internal_region" is a multi-region enum and can't be modified using the alter type command
SQLSTATE: 42809
HINT: try adding/removing the region using ALTER DATABASE

Changing the owner of the database with ALTER DATABASE ... OWNER TO ... also does not change the owner of crdb_internal_region.

The implication of this is that whatever user/role creates the database must exist for the lifetime of the database -- you can't drop the user/role without first dropping the database.

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/sql-schema (found keywords: ALTER DATABASE)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}