Basic querying now works after the SET NAMES 'UTF8' fix, which is great.

We have now come to the next hurdle when testing a simple migrate.

When running the following command
npx prisma migrate dev --name init

//schema.prisma
// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id    Int    @id @default(autoincrement())
  name  String
}

Error: Migration engine error:
db error: ERROR: Postgres function version() is not supported - Statement: 'with pg_namespace as (
  select case schema_name when 'pg_catalog' then 11 when 'public' then 2200 else 0 end as oid,
        schema_name as nspname, null as nspowner, null as nspacl
  from information_schema.schemata
)
SELECT EXISTS(SELECT 1 FROM pg_namespace WHERE nspname = $1), version()'

Here is where the relevant line in Primsa which throw the error.

This error is also thrown when directly querying the SELECT version(); in the spanner console.

How should we proceed?

Feature Request: Add support for Prisma #589

Description

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions