relation users already exists

cockpit on  feature/variant-hidden-flag [!?] via 🥟 v1.2.15 on ☁️
❯ cat drizzle/0069_variant_hidden_flag.sql
ALTER TABLE "variants" ADD COLUMN "hidden" boolean DEFAULT false NOT NULL;%

cockpit on  feature/variant-hidden-flag [!?] via 🥟 v1.2.15 on ☁️
❯ bunx drizzle-kit migrate
No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/binajmen/Developer/fbnb/cockpit/drizzle.config.ts'
Using 'pg' driver for database querying
[⣷] applying migrations...error: relation "users" already exists
    at /Users/binajmen/Developer/fbnb/cockpit/node_modules/pg/lib/client.js:535:17
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at <anonymous> (/Users/binajmen/Developer/fbnb/cockpit/node_modules/src/pg-core/dialect.ts:102:7)
    at NodePgSession.transaction (/Users/binajmen/Developer/fbnb/cockpit/node_modules/src/node-postgres/session.ts:193:19)
    at PgDialect.migrate (/Users/binajmen/Developer/fbnb/cockpit/node_modules/src/pg-core/dialect.ts:95:3)
    at migrate (/Users/binajmen/Developer/fbnb/cockpit/node_modules/src/node-postgres/migrator.ts:10:2) {
  length: 99,
  severity: 'ERROR',
  code: '42P07',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'heap.c',
  line: '1160',
  routine: 'heap_create_with_catalog'
}
Was this page helpful?