CODEWITHSUNDEEP
postgresqlsupabasevaultsupabase-database
Charles Kasasira
Charles Kasasira

Reputation: 320

Failed to create and edit tables in Supabase, "Failed to create pg.columns:..."

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.

Upvotes: 5

Views: 2020

Answers (2)

Axit Poojara
Axit Poojara

Reputation: 1

you can get this error because for other column has values and this new column has no values so if you create a column at the time where where other column has value so create with default value , it will create easily

Upvotes: 0

Charles Kasasira
Charles Kasasira

Reputation: 320

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.

Upvotes: 4

Related Questions