JPA : Can not run ddl-auto=update with Spring Boot

Caused by: org.postgresql.util.PSQLException: ERROR: column i.indproc does not exist


This may happen while trying to update development db schema without loosing data and adding schema updates into development db:


  1. spring.jpa.hibernate.ddl-auto=update

Problem is with Postgresql JDBC driver 9.1-901-1.jdbc4:

  1. compile group: 'postgresql', name: 'postgresql', version: '9.1-901-1.jdbc4'
Upgrade it to latest version 42.2.5 in build.gradle:

  1. compile group: 'org.postgresql', name: 'postgresql', version: '42.2.5'
Maven repository:
https://mvnrepository.com/artifact/org.postgresql/postgresql/42.2.5

maven:
<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.2.5</version>
</dependency>

No comments:

Post a Comment