Schema migration failing

Queries and Resources
1

I'm trying to migrate two tables from Production to Staging using the Schema Migrator for Retool DB.

The tool generates a script; however, this fails with this error: Error: cannot drop function retool_refresh_updated_timestamp_function_updated_at() because other objects depend on it

I can't edit the script. Any ideas on how to resolve this?

Cheers

2

Hi @DuncanRitchie, could you share a screenshot of the whole migration? It looks like it's trying to drop an existing function that some of your data is dependent on. There are a couple of things we can do to go around this, knowing which table(s) are relevant for your migration would be a great place to start.