postgres push issue
have a table like this
db push wants to do this
export const orgUserInfo = pgTable(
"org_user_info",
{
data: jsonb("data"),
orgId: text("org_id").notNull(),
userId: text("user_id").notNull(),
},
(table) => ({
primary: primaryKey(table.userId, table.orgId),
})
)export const orgUserInfo = pgTable(
"org_user_info",
{
data: jsonb("data"),
orgId: text("org_id").notNull(),
userId: text("user_id").notNull(),
},
(table) => ({
primary: primaryKey(table.userId, table.orgId),
})
)db push wants to do this
ALTER TABLE "org_user_info" DROP CONSTRAINT "org_user_info_pkey";
ALTER TABLE "org_user_info" ADD PRIMARY KEY ("user_id");ALTER TABLE "org_user_info" DROP CONSTRAINT "org_user_info_pkey";
ALTER TABLE "org_user_info" ADD PRIMARY KEY ("user_id");The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Similar Threads
Was this page helpful?
