Error when creating a new table: "failed to create pg.columns: must be owner of event trigger pgsodium_trg_mask_update"

[JeongJuhyeon]

As the title says - when adding a new table to my project through the table editor, I get an error popup with the following error

failed to create pg.columns: must be owner of event trigger pgsodium_trg_mask_update

[GaryAustin1]

Are you running Prisma?
Any way at https://discord.com/channels/839993398554656828/1105953777036566599/1105956176828563496
This is suggested, likely Prisma migrate messed up the tables grants in those cases.

drop view vault.decrypted_secrets;
drop extension supabase_vault;
drop extension pgsodium;
create extension pgsodium;
create extension supabase_vault;

[sitoftonic]

This worked for me, but I was not using Prisma at all nor any migration tool.
For anyone having the same problem, use this sequence of commands, but keep in mind this will drop any secrets configured in the vault. To make sure you don't have secrets in the vault, run the following command before running the sequence:

select count(*) from vault.secrets -- if result is 0, should be able to run the sequence without any problem

[Aladdin4u]

As the title says - when adding a new table to my project through the table editor, I get an error popup with the following error

failed to create pg.columns: must be owner of event trigger pgsodium_trg_mask_update

I'm have the same problem

[alfredosalzillo]

I'm having the same problem

[2023-07-25 21:50:50] [42501] ERROR: must be owner of event trigger pgsodium_trg_mask_update
[2023-07-25 21:50:50] Where: SQL function "disable_security_label_trigger" statement 1
[2023-07-25 21:50:50] SQL statement "SELECT pgsodium.disable_security_label_trigger()"
[2023-07-25 21:50:50] PL/pgSQL function pgsodium.update_mask(oid,boolean) line 3 at PERFORM
[2023-07-25 21:50:50] SQL statement "SELECT pgsodium.update_mask(objoid, debug)
[2023-07-25 21:50:50] FROM pg_catalog.pg_seclabel sl
[2023-07-25 21:50:50] JOIN pg_catalog.pg_class cl ON (cl.oid = sl.objoid)
[2023-07-25 21:50:50] WHERE label ilike 'ENCRYPT%'
[2023-07-25 21:50:50] AND cl.relowner = session_user::regrole::oid
[2023-07-25 21:50:50] AND provider = 'pgsodium'
[2023-07-25 21:50:50] 	   AND objoid::regclass != 'pgsodium.key'::regclass"
[2023-07-25 21:50:50] PL/pgSQL function pgsodium.update_masks(boolean) line 3 at PERFORM
[2023-07-25 21:50:50] SQL statement "SELECT pgsodium.update_masks()"
[2023-07-25 21:50:50] PL/pgSQL function pgsodium.trg_mask_update() line 9 at PERFORM

[davidhariri]

Same issue here

failed to create pg.columns: must be owner of event trigger pgsodium_trg_mask_update

[landmann]

Same issue