S

Supabase•4mo ago

sheisty6

Branching Drift Caused by Storage Triggers

Hello,

I am trying to create a persistent staging branch that is in sync with production. The process I used was:

1. Create branch

   dev

   dev

   off of productionproduction
2. Run a data dump and run the dump script in

   dev

   dev

   SQL editor
3. Run a query in productionproduction to get all triggers so that I can manually copy them over (they don't seem to come over thru the dump)

I'm running into issues copying over some triggers on the storage table, with commands like:
CREATE TRIGGER prefixes_delete_hierarchy AFTER DELETE ON storage.prefixes FOR EACH ROW EXECUTE FUNCTION storage.delete_prefix_hierarchy_trigger();CREATE TRIGGER prefixes_delete_hierarchy AFTER DELETE ON storage.prefixes FOR EACH ROW EXECUTE FUNCTION storage.delete_prefix_hierarchy_trigger();

Failing with error:
ERROR: 42P01: relation "storage.prefixes" does not existERROR: 42P01: relation "storage.prefixes" does not exist

I've attached a screenshot of the productionproduction storage triggers. I do not remember creating these, were they a byproduct of some setting? Can I safely delete them in productionproduction, or copy them over to developdevelop?

Thanks!