immortal Posts - Answer Overflow

immortal

•Created by immortal on 8/14/2024 in #help

getting DROP SEQUENCE prompt while doing db push

after i took the update I'm getting DROP SEQUENCE prompt while doin db push and its failing even if there is no changes in the table , my table is this :

import { pgTable, serial, text, timestamp, integer, real, json, boolean } from "drizzle-orm/pg-core";

export const branchLocationTable = pgTable("branchLocation", {
    id: serial("id").primaryKey(),
    locationId: integer("locationId"),
    branchId: integer("branchId"),
    activeStatus: boolean("activeStatus"),
});

export type BranchLocation = typeof branchLocationTable.$inferSelect;

im getting prompt: [✓] Pulling schema from database... Warning You are about to execute current statements: DROP SEQUENCE "public"."branchLocation_id_seq"; and the error is : PostgresError: cannot drop sequence "branchLocation_id_seq" because other objects depend on it

1 replies

Gaming

Programming