Identifier is too long (should not exceed 63 characters)

Hello guys. I've got too long constraint id generated by drizzle kit in migration files. Is it safe to apply such migration? Maybe there is a way how I can set custom constraint id for some tables? Here is my schema

export const customerVehicleClaims = pgTable('customer_vehicle_claims', {
    claimsid: text('claimsid').primaryKey().notNull(),
    customervehicleid: integer('customervehicleid')
        .notNull()
        .references(() => customervehicle.customervehicleid),
    createdAt: timestamp('created_at', { mode: 'string' }).defaultNow().notNull(),
    updatedAt: timestamp('updated_at', { mode: 'string' }),
    customerid: integer('customerid')
        .notNull()
        .references(() => customer.customerid),
    vehicleid: integer('vehicleid')
        .notNull()
        .references(() => vehicle.vehicleid),
});

export const customerVehicleClaims = pgTable('customer_vehicle_claims', {
    claimsid: text('claimsid').primaryKey().notNull(),
    customervehicleid: integer('customervehicleid')
        .notNull()
        .references(() => customervehicle.customervehicleid),
    createdAt: timestamp('created_at', { mode: 'string' }).defaultNow().notNull(),
    updatedAt: timestamp('updated_at', { mode: 'string' }),
    customerid: integer('customerid')
        .notNull()
        .references(() => customer.customerid),
    vehicleid: integer('vehicleid')
        .notNull()
        .references(() => vehicle.vehicleid),
});

export const customerVehicleClaims = pgTable('customer_vehicle_claims', {
    claimsid: text('claimsid').primaryKey().notNull(),
    customervehicleid: integer('customervehicleid')
        .notNull()
        .references(() => customervehicle.customervehicleid),
    createdAt: timestamp('created_at', { mode: 'string' }).defaultNow().notNull(),
    updatedAt: timestamp('updated_at', { mode: 'string' }),
    customerid: integer('customerid')
        .notNull()
        .references(() => customer.customerid),
    vehicleid: integer('vehicleid')
        .notNull()
        .references(() => vehicle.vehicleid),
});

export const customerVehicleClaims = pgTable('customer_vehicle_claims', {
    claimsid: text('claimsid').primaryKey().notNull(),
    customervehicleid: integer('customervehicleid')
        .notNull()
        .references(() => customervehicle.customervehicleid),
    createdAt: timestamp('created_at', { mode: 'string' }).defaultNow().notNull(),
    updatedAt: timestamp('updated_at', { mode: 'string' }),
    customerid: integer('customerid')
        .notNull()
        .references(() => customer.customerid),
    vehicleid: integer('vehicleid')
        .notNull()
        .references(() => vehicle.vehicleid),
});

Here is the generated sql

DO
$$
    BEGIN
        ALTER TABLE "customer_vehicle_claims"
            ADD CONSTRAINT "customer_vehicle_claims_customervehicleid_customervehicle_customervehicleid_fk" FOREIGN KEY ("customervehicleid") REFERENCES "customervehicle" ("customervehicleid") ON DELETE no action ON UPDATE no action;
    EXCEPTION
        WHEN duplicate_object THEN null;
    END
$$;
--> statement-breakpoint

DO
$$
    BEGIN
        ALTER TABLE "customer_vehicle_claims"
            ADD CONSTRAINT "customer_vehicle_claims_customervehicleid_customervehicle_customervehicleid_fk" FOREIGN KEY ("customervehicleid") REFERENCES "customervehicle" ("customervehicleid") ON DELETE no action ON UPDATE no action;
    EXCEPTION
        WHEN duplicate_object THEN null;
    END
$$;
--> statement-breakpoint

DO
$$
    BEGIN
        ALTER TABLE "customer_vehicle_claims"
            ADD CONSTRAINT "customer_vehicle_claims_customervehicleid_customervehicle_customervehicleid_fk" FOREIGN KEY ("customervehicleid") REFERENCES "customervehicle" ("customervehicleid") ON DELETE no action ON UPDATE no action;
    EXCEPTION
        WHEN duplicate_object THEN null;
    END
$$;
--> statement-breakpoint

DO
$$
    BEGIN
        ALTER TABLE "customer_vehicle_claims"
            ADD CONSTRAINT "customer_vehicle_claims_customervehicleid_customervehicle_customervehicleid_fk" FOREIGN KEY ("customervehicleid") REFERENCES "customervehicle" ("customervehicleid") ON DELETE no action ON UPDATE no action;
    EXCEPTION
        WHEN duplicate_object THEN null;
    END
$$;
--> statement-breakpoint

Alex.devOP•8/8/23, 5:36 PM

Forgot to mention I'm using RDS Aurora for postgres

Alex.devOP•8/9/23, 4:03 PM

@Dan Kochetov can you help, please?

Dan•8/9/23, 4:04 PM

passing to @Andrew Sherman

Alex.devOP•8/10/23, 4:40 PM

https://tenor.com/view/roc-rocfriesepoort-friesepoort-fries-school-gif-22392219

Tenor

Alex.devOP•8/10/23, 4:40 PM

@Andrew Sherman, please, help)

Andrii Sherman•8/10/23, 5:42 PM

you found me

Andrii Sherman•8/10/23, 5:43 PM

it won't work now if you are using drizzle-kit for migration management. We will add a new API in drizzle-orm to provide custom names for fk and pk. After that evertyhing will work as expected

Andrii Sherman•8/10/23, 5:43 PM

I'll try to make a high priority for this task

Andrii Sherman•8/10/23, 5:43 PM

I know it's blocking some other devs already

Jona Anders•8/10/23, 6:22 PM

For now, you can just go into a migration file and replace or remove the parts. I know, this isn't pretty, but it does work. Just note that for every migration drizzle kit will try to rename it, so you have to delete the ALTER queries. Maybe just create a file or a note that includes the names of the keys so you can search and replace quickly. Or, if you have to much time to automate a task that you could do in a few seconds manually, write a short script that does it automatically

Alex.devOP•8/10/23, 7:42 PM

thank you guys so much for help!

Identifier is too long (should not exceed 63 characters)

Similar Threads

Similar Threads

Similar Threads