Column of relation already exists

I have a couple of tables

export const schoolReferences = pgTable(
  'school_references',
  {
    id: serial('id').primaryKey(),
    sanityId: text('sanity_id').notNull().unique(),
    name: text('name'),
  },
  (table) => [uniqueIndex('sanity_id_idx').on(table.sanityId)],
)

export const players = pgTable('players', {
  id: serial('id').primaryKey(),
  firstName: text('first_name').notNull(),
  lastName: text('last_name').notNull(),
  currentSchoolId: integer('current_school_id').references(() => schoolReferences.id),
})

export const transferPortalEntries = pgTable('transfer_portal_entries', {
  id: serial('id').primaryKey(),
  playerId: integer('player_id')
    .references(() => players.id)
    .notNull(),
  previousSchoolId: integer('previous_school_id')
    .references(() => schoolReferences.id)
    .notNull(),
  commitmentSchoolId: integer('commitment_school_id').references(() => schoolReferences.id),
})

export const schoolReferences = pgTable(
  'school_references',
  {
    id: serial('id').primaryKey(),
    sanityId: text('sanity_id').notNull().unique(),
    name: text('name'),
  },
  (table) => [uniqueIndex('sanity_id_idx').on(table.sanityId)],
)

export const players = pgTable('players', {
  id: serial('id').primaryKey(),
  firstName: text('first_name').notNull(),
  lastName: text('last_name').notNull(),
  currentSchoolId: integer('current_school_id').references(() => schoolReferences.id),
})

export const transferPortalEntries = pgTable('transfer_portal_entries', {
  id: serial('id').primaryKey(),
  playerId: integer('player_id')
    .references(() => players.id)
    .notNull(),
  previousSchoolId: integer('previous_school_id')
    .references(() => schoolReferences.id)
    .notNull(),
  commitmentSchoolId: integer('commitment_school_id').references(() => schoolReferences.id),
})

I went to add a new column name to the school_references table & remove a column from transfer_portal_entries and ran drizzle-kit generate followed by drizzle-kit migrate. However, when I run the migrate command I get applying migrations...PostgresError: column "name" of relation "school_references" already exists. I previously added name via the Supabase dashboard to test something and then removed it but it was back after running generate and migrate the other day (which I want). I'm not sure why it's complaining now.

5 Replies

Spark•2mo ago

I am running into something similar due to the IF NOT EXISTS being removed I think https://github.com/drizzle-team/drizzle-orm/releases/tag/drizzle-kit%400.30.0

GitHub

Release [email protected] · drizzle-team/drizzle-orm

Starting from this update, the PostgreSQL dialect will align with the behavior of all other dialects. It will no longer include IF NOT EXISTS, $DO, or similar statements, which could cause incorrec...

jsingleton37OP•2mo ago

I just upgraded from 0.36.4 to 0.38.1 of drizzle-orm and 0.28.1 to 0.30.0 of drizzle-kit and now I can't even do drizzle-kit generate 😭 I get

Error: [supabase/migrations/meta/0017_snapshot.json, supabase/migrations/meta/0018_snapshot.json] are pointing to a parent snapshot: supabase/migrations/meta/0017_snapshot.json/snapshot.json which is a collision.

Error: [supabase/migrations/meta/0017_snapshot.json, supabase/migrations/meta/0018_snapshot.json] are pointing to a parent snapshot: supabase/migrations/meta/0017_snapshot.json/snapshot.json which is a collision.

Kryp Arnold•2w ago

@Spark @jsingleton37 sorry for mention but have you guys find any solution?

Spark•2w ago

I don't have this problem anymore, but I don't remember if I just started a new project so that is why? Are you adding a default to the new fields?

Kryp Arnold•2w ago

i just made a basic change to my schema and then i got "PostgresError: relation "authenticator" already exists" this error, but my change doesnt have anything to do with it, here is my migration file

ALTER TABLE "user" ADD COLUMN "username" text;

ALTER TABLE "user" ADD COLUMN "username" text;

i fixed it by downgrading drizzle-kit to 0.30.0 i was using 0.30.1

Gaming

Programming

Column of relation already exists

Did you find this page helpful?