3

I have failed to create or edit tables in Supabase. It is showing an error message "Failed to create pg.columns: must be the owner of event trigger pgsodium_trg_mask_update". I think it has something to do with the launch of supabase vault, but I don't have the vault feature on my settings dashboard for now.

I am using supabase's free tier.

enter image description here

I have tried deleting the vault and pgsodium triggers since these are new but still failed to create the tables. I have even failed to remove the pgsodium extension. I am looking for a way to create the secret keys or disable this feature and have supabase working as before and I should be able to create tables.

Charles Kasasira
  • 240
  • 1
  • 5
  • 15
  • 1
    Hmm, would you mind contacting support about this issue? https://app.supabase.com/support/new – dshukertjr Feb 27 '23 at 05:45
  • Seeing this as well when trying to migrate from a MySQL database to Supabase using [nmig](https://github.com/AnatolyUss/nmig) – brad Apr 25 '23 at 17:28
  • Having the same error when trying to use `ALTER TABLE` to add a foreign key. – Camilo May 21 '23 at 20:56

1 Answers1

1

I have not found a solution yet for the table editor but I am using the SQL editor. The tables can be created and edited successfully from there.

Charles Kasasira
  • 240
  • 1
  • 5
  • 15