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.

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

PostGis views access error #15361

Closed
Kalo0m opened this issue Sep 16, 2022 · 0 comments · Fixed by prisma/prisma-engines#3198
Closed

PostGis views access error #15361

Kalo0m opened this issue Sep 16, 2022 · 0 comments · Fixed by prisma/prisma-engines#3198
Assignees
Labels
bug/1-unconfirmed Bug should have enough information for reproduction, but confirmation has not happened yet. kind/bug A reported bug. team/schema Issue for team Schema. topic: migrate topic: postgis
Milestone

Comments

@Kalo0m
Copy link

Kalo0m commented Sep 16, 2022

related to this issue (#14182), it seems that postgis has also raster_columns and raster_overviews

Error: P3016

The fallback method for database resets failed, meaning Migrate could not clean up the database entirely. Original error: 
db error: ERROR: must be owner of view raster_columns
   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

How to reproduce

  • have postgres with PostGis enabled
  • Run prisma migrate dev

Expected behavior

migrates

Prisma information

Environment & setup

OS: MacOs
Database: PostgreSQL
Node.js version: 14.7.0

Prisma version

4.3.1

Originally posted by @Kalo0m in #14182 (comment)

@Kalo0m Kalo0m changed the title PostGis views access PostGis views access error Sep 16, 2022
@jkomyno jkomyno self-assigned this Sep 16, 2022
@jkomyno jkomyno added kind/bug A reported bug. topic: migrate team/schema Issue for team Schema. labels Sep 16, 2022
@janpio janpio added the bug/1-unconfirmed Bug should have enough information for reproduction, but confirmation has not happened yet. label Sep 16, 2022
@janpio janpio added this to the 4.4.0 milestone Sep 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug/1-unconfirmed Bug should have enough information for reproduction, but confirmation has not happened yet. kind/bug A reported bug. team/schema Issue for team Schema. topic: migrate topic: postgis
Projects
None yet
3 participants