Drizzle Kit: Push Wants to Update Unchanged Column Type

Similar to this post: "1109290137688489984" Getting the following when running npx drizzle-kit push:pg
Warning Found data-loss statements:
· You're about to change fulfillment_date column type from timestamp(6) with time zone to timestamp (6) with time zone with 110 items
Warning Found data-loss statements:
· You're about to change fulfillment_date column type from timestamp(6) with time zone to timestamp (6) with time zone with 110 items
4 Replies
djarran
djarranOP14mo ago
Title of the other post: "drizzle-kit: push wants to change column type that hasn't changed"
djarran
djarranOP14mo ago
Attached is a link to a GitHub Issue that says the issue has been fixed https://github.com/drizzle-team/drizzle-kit-mirror/issues/59
GitHub
[BUG]: push:mysql trying to truncate table with boolean · Issue #5...
I've been playing around a bit with the new push:mysql command and noticed that it's trying to wipe my table any time i run it because it's supposedly trying to change the type to '...
djarran
djarranOP14mo ago
Only difference between the two column types is a space between timestamp and (6) here is the column for the table: export const cateringOrders = pgTable('catering_orders', { fulfillmentDate: timestamp('fulfillment_date', { precision: 6, withTimezone: true }), });
djarran
djarranOP14mo ago
Found a similar issue and updated it with my findings on this issue: https://github.com/drizzle-team/drizzle-kit-mirror/issues/177
GitHub
[BUG]: timstamp space in postgresql · Issue #177 · drizzle-team/dri...
What version of drizzle-orm are you using? 0.28.5 What version of drizzle-kit are you using? 0.19.13 Describe the Bug I'm using postgresql and i have this simple table: export const users = pgT...
Want results from more Discord servers?
Add your server