AH
Explore posts from serversPPrisma
•Created by AH on 9/16/2024 in #help-and-questions
schema "extensions" does not exist' error in shadow DB during initial migration on Neon
When running 'prisma migrate dev', I get this error on my first migration:
'Migration 0_init failed to apply cleanly to the shadow database.
Error: ERROR: schema "extensions" does not exist'
The migration includes 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA "extensions";'. However, the 'extensions' schema and uuid-ossp extension already exist in my database.
What's causing this shadow database issue, and how can I resolve it without editing existing migrations?
2 replies
PPrisma
•Created by AH on 8/28/2024 in #help-and-questions
TypedSQL - JSONB fields
Using TypedSQL, I noticed that JSONB fields are inferred as JsonValue. Is there a way to get more specific type inference for complex JSON structures in PostgreSQL queries, or is this a current limitation of TypedSQL?
2 replies