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;

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

Drizzle Team•2y ago

immortal

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;

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;

getting DROP SEQUENCE prompt while doing db push

Similar Threads

getting DROP SEQUENCE prompt while doing db push

Similar Threads

Similar Threads

Similar Threads