2.3.0 -> 2.3.3 migration is broken with postgresql #4362
Description
Bug report:
When updating dragonfly managers with "migrate: true" set up with postgresql 16, an error appears:
ERROR: type "longtext" does not exist at character 73
STATEMENT: ALTER TABLE "audit" ALTER COLUMN "detail" TYPE longtext USING "detail"::longtext
Expected behavior:
The text type in postgresql is unlimited and the longtext type doesn't exist at all. The alter should not happen for postgresql.
How to reproduce it:
- set up 1 dragonfly manager 2.3.0 with postgresql
- try to update to 2.3.3 and it will fail
Environment:
- Dragonfly version: 2.3.0->2.3.3
- OS: Ubuntu 22
- Kernel (e.g.
uname -a): 6.5.0-45-generic - Others: Postgresql 16