Creating enum in custom schema fails

# Bug report - [X] I confirm this is a bug with Supabase, not with my own application. - [X] I confirm I have searched the [Docs](https://docs.supabase.com), GitHub [Discussions](https://github.com/supabase/supabase/discussions), and [Discord](https://discord.supabase.com). I am experiencing this bug in local and hosted versions in slightly different ways - but seems to be related: # Local version issue For a brand new Supabase project, whenever I try to create an enum for a custom schema, either via the Studio UI or the Studio's SQL editor, it never creates the enum (even though in both cases it claims it has). The same project hosted on Supabase creates them fine. For example via the Studio UI, I create the enum, the toast appears saying it's successfully created, but the inline table with the created enums never shows my new one. # Hosted version issue For a brand new Supabase project, I am able to create an enum for a custom schema fine and it shows up, however whenever I try to then use that enum in a new column of a table within that custom schema, I get the error: `failed to create pg.columns: type "my_enum_name" does not exist`. This issue in the hosted version again does not happen if I'm using the `public` schema.