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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/75286169-758d-4ba4-b4ef-708aec723829n%40googlegroups.com.
