Hello! I am new to Prisma and trying to figure ou...
# orm-help
e
Hello! I am new to Prisma and trying to figure out how to use Postgis extensions with my prisma schema. How do I tell Prisma to ignore a set of views of tables? I get the following error when I run a migrate:
Copy code
Error: P3016

The fallback method for database resets failed, meaning Migrate could not clean up the database entirely. Original error: 
db error: ERROR: cannot drop view geography_columns because extension postgis requires it
HINT: You can drop extension postgis instead.
   0: sql_migration_connector::best_effort_reset
             at migration-engine/connectors/sql-migration-connector/src/lib.rs:290
   1: migration_core::state::DevDiagnostic
             at migration-engine/core/src/state.rs:250
My prisma version is:
Copy code
=> prisma --version
prisma                  : 3.13.0
@prisma/client          : Not found
Current platform        : darwin
Query Engine (Node-API) : libquery-engine efdf9b1183dddfd4258cd181a72125755215ab7b (at ../../../../../usr/local/lib/node_modules/prisma/node_modules/@prisma/engines/libquery_engine-darwin.dylib.node)
Migration Engine        : migration-engine-cli efdf9b1183dddfd4258cd181a72125755215ab7b (at ../../../../../usr/local/lib/node_modules/prisma/node_modules/@prisma/engines/migration-engine-darwin)
Introspection Engine    : introspection-core efdf9b1183dddfd4258cd181a72125755215ab7b (at ../../../../../usr/local/lib/node_modules/prisma/node_modules/@prisma/engines/introspection-engine-darwin)
Format Binary           : prisma-fmt efdf9b1183dddfd4258cd181a72125755215ab7b (at ../../../../../usr/local/lib/node_modules/prisma/node_modules/@prisma/engines/prisma-fmt-darwin)
Default Engines Hash    : efdf9b1183dddfd4258cd181a72125755215ab7b
Studio                  : 0.459.0
n
Hey Eric 👋 You can mark a migration as resolved so that the particular migration isn’t executed: migrate resolve Can you try marking the migration which creates the views as resolved? Also here’s the Feature Request for support of PostGIS #2789
🙌 1