Menu

#354 PostgreSQL Compatibility: support information_schema.sequences compatibility

open-fixed
None
5
2022-07-28
2019-12-11
aLeXx
No

Case:
Hibernate Core 5.4.9.Final (comes with Spring Boot v2.2.2.RELEASE)
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQL10Dialect
Test against
spring.datasource.url=jdbc:hsqldb:mem:testdb;sql.syntax_pgs=true

Failed with: java.sql.SQLException: Column not found: start_value
Actual Hibernate query: select * from information_schema.sequences

According to [1] there is only NEXT_VALUE column available since PostgreSQL sequences view [2] is more complex.

  1. http://hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_number_sequence
  2. https://www.postgresql.org/docs/10/infoschema-sequences.html

Discussion

  • Fred Toussi

    Fred Toussi - 2019-12-11

    Thanks for reporting. Column added and committed to SVN base/trunk.

     
    • aLeXx

      aLeXx - 2019-12-12

      Now its working as expected, thanks!

       
  • Fred Toussi

    Fred Toussi - 2022-07-28
    • status: open --> open-fixed
     
  • Fred Toussi

    Fred Toussi - 2022-07-28
    • assigned_to: Fred Toussi
     

Log in to post a comment.

MongoDB Logo MongoDB