https://connect.hyland.com/t5/nuxeo-forum/problem-with-postgresql-with-nuxeo-lts-2023/m-p/490218#M15840 <P>Hi, we have a problem using postgresql on nuxeo lts 2023 docker image. On h2 db it works, but as soon as we configure postgre connection in configuration we get error<BR /><BR /></P><P>SQL type mismatch for "task"."id": expected VARCHAR, database has INTEGER / int4(10)<BR />Component service:org.nuxeo.ecm.core.repository.RepositoryServiceComponent notification of application started failed: java.sql.SQLException: Error executing: ALTER TABLE "task" ADD COLUMN "accepted" bool : ERROR: relation "task" does not exist &nbsp;</P><P>It looks as if no migration was performed, this table does not exist in the DB</P> Wed, 28 May 2025 06:41:36 GMT lzuzanak 2025-05-28T06:41:36Z https://connect.hyland.com/t5/nuxeo-forum/problem-with-postgresql-with-nuxeo-lts-2023/m-p/490218#M15840 <P>Hi, we have a problem using postgresql on nuxeo lts 2023 docker image. On h2 db it works, but as soon as we configure postgre connection in configuration we get error<BR /><BR /></P><P>SQL type mismatch for "task"."id": expected VARCHAR, database has INTEGER / int4(10)<BR />Component service:org.nuxeo.ecm.core.repository.RepositoryServiceComponent notification of application started failed: java.sql.SQLException: Error executing: ALTER TABLE "task" ADD COLUMN "accepted" bool : ERROR: relation "task" does not exist &nbsp;</P><P>It looks as if no migration was performed, this table does not exist in the DB</P> Wed, 28 May 2025 06:41:36 GMT https://connect.hyland.com/t5/nuxeo-forum/problem-with-postgresql-with-nuxeo-lts-2023/m-p/490218#M15840 lzuzanak 2025-05-28T06:41:36Z https://connect.hyland.com/t5/nuxeo-forum/problem-with-postgresql-with-nuxeo-lts-2023/m-p/490334#M15842 <P>Hello, are you a customer or are you using a custom Nuxeo build?</P> Mon, 02 Jun 2025 09:33:20 GMT https://connect.hyland.com/t5/nuxeo-forum/problem-with-postgresql-with-nuxeo-lts-2023/m-p/490334#M15842 ttoine 2025-06-02T09:33:20Z