I saw the change in 2.0.202 and tried with that version without `MODE=PostgreSQL` and with `org.hibernate.dialect.H2Dialect` I get the following error: ``` ERROR: NULL not allowed for column "ID"; SQL statement: insert into users (id, password, session_id, username) values (null, ?, ?, ?) [23502-202] ```
with `MODE=PostgreSQL` and `org.hibernate.dialect.PostgreSQL10Dialect` I get this one: ``` ERROR: Sequence "USERS_ID_SEQ" not found; SQL statement: select currval('users_id_seq') [90036-202] ``` These are complete new errors that I didn't have on 1.4.200 > usage of PostgreSQL***Dialect with H2 may still fail at any point, H2 should only be used with H2Dialect. that's not what the documentation says: at the contrary it advises to not use the H2Dialect in compatibility mode (while not all the features might be supported) https://h2database.com/html/tutorial.html?highlight=dialect&search=dialect#using_hibernate Il giorno martedì 30 novembre 2021 alle 02:39:44 UTC+1 Evgenij Ryazanov ha scritto: > Hello. > > H2 2.0.202 has INFORMATION_SCHEMA.SEQUENCES.START_VALUE, but usage > of PostgreSQL***Dialect with H2 may still fail at any point, H2 should only > be used with H2Dialect. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/75286169-758d-4ba4-b4ef-708aec723829n%40googlegroups.com.