Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

db error: ERROR: cannot drop view geography_columns because extension postgis requires it #14182

Closed
capaj opened this issue Jul 6, 2022 · 0 comments · Fixed by prisma/prisma-engines#3051
Closed

db error: ERROR: cannot drop view geography_columns because extension postgis requires it #14182

capaj opened this issue Jul 6, 2022 · 0 comments · Fixed by prisma/prisma-engines#3051
Labels
bug/2-confirmed Bug has been reproduced and confirmed. kind/bug A reported bug. team/schema Issue for team Schema. tech/engines/migration engine Issue in the Migration Engine tech/engines Issue for tech Engines. topic: migrate topic: postgis
Milestone
4.1.0

Comments

@capaj
Copy link

capaj commented Jul 6, 2022 •
edited

Bug description

this might have been reported here already #7764, but it's definitely still failing even on 4.0.0

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:288
   1: migration_core::state::Reset
             at migration-engine/core/src/state.rs:341

How to reproduce

  1. have postgres with PostGis enabled
  2. Run prisma migrate dev

Expected behavior

migrates

Prisma information

Environment & setup

  • OS: Ubuntu
  • Database: PostgreSQL
  • Node.js version: 18.4.0

Prisma Version

4.0.0
@capaj capaj added the kind/bug A reported bug. label Jul 6, 2022
@capaj capaj mentioned this issue Jul 6, 2022
Closed
@tomhoule tomhoule added bug/1-unconfirmed Bug should have enough information for reproduction, but confirmation has not happened yet. tech/engines Issue for tech Engines. topic: postgis topic: migrate tech/engines/migration engine Issue in the Migration Engine process/candidate and removed process/candidate labels Jul 7, 2022
@pimeys pimeys added the team/schema Issue for team Schema. label Jul 7, 2022
@jkomyno jkomyno added bug/2-confirmed Bug has been reproduced and confirmed. and removed bug/1-unconfirmed Bug should have enough information for reproduction, but confirmation has not happened yet. labels Jul 8, 2022
@jkomyno jkomyno mentioned this issue Jul 8, 2022
Merged
@janpio janpio added this to the 4.1.0 milestone Jul 8, 2022
@Kalo0m Kalo0m mentioned this issue Sep 16, 2022
Closed
@janpio janpio modified the milestones: 4.1.0, 4.4.0 Sep 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug/2-confirmed Bug has been reproduced and confirmed. kind/bug A reported bug. team/schema Issue for team Schema. tech/engines/migration engine Issue in the Migration Engine tech/engines Issue for tech Engines. topic: migrate topic: postgis
Projects
None yet
Milestone
4.1.0
Development

Successfully merging a pull request may close this issue.

fix: add prevent geography_columns from PostGIS to be deleted on migrations prisma/prisma-engines
5 participants
@pimeys @janpio @capaj @jkomyno @tomhoule