Hello.
I think that is an old “Strapi” problem when the project uses Postgres.
Take a look on this topic from 2022:
Personally I changed my database to MySql because I was facing this problem. Its solved my problem even though I prefer the Postgres for a lot of reasons.