Details
-
Type:
Story
-
Status: Resolved (View Workflow)
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 25.0.0
-
Fix Version/s: 25.0.0
-
Component/s: Database
-
Security Level: Default (Default Security Scheme)
-
Labels:None
-
Sprint:Horizon 2019 - August 28th, Horizon 2019 - September 4th
Description
In 25.0.0 we now depend on the jsonb datatype to be available in PostgreSQL.
If users are using an older version of PostgreSQL (say postgresql-server-9.2.24-1.el7_5.x86_64 which is available in the CentOS 7 repositories) then install -dis will fail with:
Caused by: org.postgresql.util.PSQLException: ERROR: type "jsonb" does not exist Position: 175 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352) ... 20 more
We should present the user with an error describing the minimum supported version instead.