drizzle-team / drizzle-team/drizzle-orm

[BUG]: it's still showing that the column types are incompatible even though I have changed the type

Open
#3,589 4 comments 1 reaction 0 assignees View on GitHub
bug db/postgres drizzle/kit priority
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [X] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

^0.36.0

### What version of `drizzle-kit` are you using?

^0.27.1

### Other packages

_No response_

### Describe the Bug

I have changed the type of the `user_id` column from integer to text,
I was referencing this column in two other columns as well so even though in my migrations files it's showing that it altered the type of all the tables("foreign key included") it's saying that types are incompatible.
I have some existing data in the tables which is of type integer but from now on I want to change the type of all tables from integer to text

![Screenshot (705)](https://github.com/user-attachments/assets/598e0509-993c-4118-b2ed-e5e8c5158274)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.