dawn dove
I'm using payload with postgres / drizzle in a dev environment, and ran into an issue. I haven't deployed yet or generated any migrations, so the dev system is automatically updating my table schemas when I change the collections in code. I'm aware that I need to handle this properly and set up migrations before deploying.
On removing a field in a collection with a Point GIS datatype, drizzle is attempting to drop the geospatial database, which is failing, as it's required by the postgres extension.
"error: cannot drop view geography_columns because extension postgis requires it"
I'm not sure why removing a field in a collection should cause this, but it looks like with a full drizzle setup, this should be specified in a drizzle.config.ts file
extensionsFilters: ['postgis']
I'm not sure where to specify this in payload config, or if it's possible to override the settings in the bundled drizzle kit. Any pointers gratefully received.
short steppe