Drizzle trying to delete PostGIS tables.
I've just installed the PostGIS integration which adds certain tables.
Now when I try to do my normal db:push, I'm getting the following error:
error: "geography_columns" is not a table
It's also mentioning the following:
You're about to delete spatial_ref_sys table with 8500 items
Which then needs confirming?
Any advice? I'm assuming Drizzle should be ignoring these tables.
2 Replies
I've had the same issues.
I had to resort to using migrations in dev to stop it trying to delete the tables.
How did you fix it? I'm getting the same issue now.
For future people find this post and wanting to know the answer, I found it in a discussion on GitHub. Add
extensionFilters: ['postgis'] to your drizzle config file.