PrismaP
Prisma•14mo ago•
1 reply
Domica

Prisma migrate dev keeps wanting to drop my sequence

I created an empty migration file, added my sequence in. After that I ran migrate dev which will generate the sql necessary to insert my column
orderNumber Int? @unique @default(dbgenerated("nextval('order_number_seq')"))


It creates the sql for inserting that column
-- AlterTable
ALTER TABLE "Order" ADD COLUMN     "orderNumber" INTEGER DEFAULT nextval('order_number_seq');

-- CreateIndex
CREATE UNIQUE INDEX "Order_orderNumber_key" ON "Order"("orderNumber");


But after running migrate dev again, it keeps creating a new migration with this content

-- AlterTable
ALTER TABLE "Order" ALTER COLUMN "orderNumber" SET DEFAULT nextval('order_number_seq'),
ALTER COLUMN "orderNumber" DROP DEFAULT;
DROP SEQUENCE "order_number_seq";


add_sequence.sql migration - 
CREATE SEQUENCE order_number_seq START 1000000;


I'm unsure why this is happening
Was this page helpful?