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.
