LiquiBase Postgres default-schema

Question

I have this problem in my application.yaml and in my postgres database: in my database I have a schema called TRIAL in uppercase. When the application starts it does not find the schema and fails, as it is looking for it in lower case.

liquibase: change-log: classpath:/db/changelog/db.changelog-master.yaml default-schema: TRIAL enabled: true

The return error

Caused by: org.postgresql.util.PSQLException: ERROR: schema "trial" does not exist

Has anyone had the same problem? I've already tried inserting single quotes and double quotes, the result is the same.

Marco

Are you sure what is exception provide liquibase, not jpa? Could you add all log? — Jenia
– Jenia, Commented Oct 10, 2024 at 16:51
@sgtgroove did you try adding objectQuotingStrategy=QUOTE_ALL_OBJECTS — Arun Duraisamy
– Arun Duraisamy, Commented Oct 11, 2024 at 18:50

sgtgroove · Accepted Answer · 2024-10-15 08:23:31Z

1

I solved it using this:

System.setProperty("liquibase.preserveSchemaCase", "true");

in the main class

answered Oct 15, 2024 at 8:23

sgtgroove

111 silver badge1 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

LiquiBase Postgres default-schema

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related