Drizzle TeamDT
Drizzle Team•2y ago
maxpaj

Understanding what's colliding at db-push (Warning: Found data-loss statements)

I'm trying to push some schema changes to my dev environment schema and I'm running into an issue where I've already changed the type of a column, and it's already applied to the database, but this issue keeps coming up.

% npx drizzle-kit push:pg
drizzle-kit: v0.20.14
drizzle-orm: v0.30.4

No config path provided, using default path
Reading config file '/apps/web/drizzle.config.ts'
 Warning  Found data-loss statements:
· You're about to change type column type from charType to characterType with 3 items

THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED


characterType is a Postgres enum I've declared in my Drizzle schema. I'm not sure what charType is referring to, is that a Postgres data type?

However, this is the column SQL already applied to the database

alter table characters
add type "characterType" default 'Player'::"characterType" not null;


And this is the table where it is used

+------------------------------------+-----+------+
|id                                  |name |type  |
+------------------------------------+-----+------+
|92e1e5ea-2465-4262-9d94-cb73cb8ecf0a|Babbe|Player|
|3469e219-6a67-4c0a-9e2e-0176846278f8|Babbe|Player|
|0690b6ae-2ab6-4bec-a48b-f1a49c923760|Nisse|Player|
+------------------------------------+-----+------+


It all seems perfectly fine... I don't see where the issue is.

If I drop the column, then re-apply the changes to the database, Drizzle CLI does not complain.

How can I debug this?
Was this page helpful?