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 :
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
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
