`drizzle-kit migrate` fails with error `Failed query: CREATE SCHEMA IF NOT EXISTS "drizzle"`

🛠️drizzle kitSupabase📚sql

I don't understand why I'm getting this error and how to even get started fixing it. I found this GitHub issue, but it's marked as closed now. This is my

drizzle.config.ts

drizzle.config.ts

file:

import "server-only";
import { defineConfig } from "drizzle-kit";

export default defineConfig({
  out: "./server/db/drizzle",
  schema: "./server/db/schema",
  dialect: "postgresql",
  dbCredentials: { url: process.env.DATABASE_URL },
  casing: "snake_case",
  strict: true,
});

import "server-only";
import { defineConfig } from "drizzle-kit";

export default defineConfig({
  out: "./server/db/drizzle",
  schema: "./server/db/schema",
  dialect: "postgresql",
  dbCredentials: { url: process.env.DATABASE_URL },
  casing: "snake_case",
  strict: true,
});

It's not a DB connection issue, because I'm able to run

select 1

select 1

using my Drizzle DB provider just fine. The schema already exists in my Supabase DB, because I have these two commands in the init script (and I checked they do get run successfully):

CREATE SCHEMA "drizzle";
ALTER SCHEMA "drizzle" OWNER TO :"db_username";

CREATE SCHEMA "drizzle";
ALTER SCHEMA "drizzle" OWNER TO :"db_username";

GitHub

drizzle-team/drizzle-orm

ORM. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.

Drizzle Team•2mo ago

this_chord

`drizzle-kit migrate` fails with error `Failed query: CREATE SCHEMA IF NOT EXISTS "drizzle"`

🛠️drizzle kitSupabase📚sql

I don't understand why I'm getting this error and how to even get started fixing it. I found this GitHub issue, but it's marked as closed now. This is my

drizzle.config.ts

drizzle.config.ts

file:

import "server-only";
import { defineConfig } from "drizzle-kit";

export default defineConfig({
  out: "./server/db/drizzle",
  schema: "./server/db/schema",
  dialect: "postgresql",
  dbCredentials: { url: process.env.DATABASE_URL },
  casing: "snake_case",
  strict: true,
});

import "server-only";
import { defineConfig } from "drizzle-kit";

export default defineConfig({
  out: "./server/db/drizzle",
  schema: "./server/db/schema",
  dialect: "postgresql",
  dbCredentials: { url: process.env.DATABASE_URL },
  casing: "snake_case",
  strict: true,
});

It's not a DB connection issue, because I'm able to run

select 1

select 1

using my Drizzle DB provider just fine. The schema already exists in my Supabase DB, because I have these two commands in the init script (and I checked they do get run successfully):

CREATE SCHEMA "drizzle";
ALTER SCHEMA "drizzle" OWNER TO :"db_username";

CREATE SCHEMA "drizzle";
ALTER SCHEMA "drizzle" OWNER TO :"db_username";

GitHub

drizzle-team/drizzle-orm

ORM. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.

`drizzle-kit migrate` fails with error `Failed query: CREATE SCHEMA IF NOT EXISTS "drizzle"`

Similar Threads

`drizzle-kit migrate` fails with error `Failed query: CREATE SCHEMA IF NOT EXISTS "drizzle"`

Similar Threads

Similar Threads

Similar Threads