Hello. In modern versions of the SQL Standard KEY is really a non-reserved word, but it was a mistake to exclude it from the list of reserved words, because in some contexts you still cannot use it as identifier, even the SQL Standard itself has at least one such documented exclusion appeared in ISO/IEC 9075-2:2016 TECHNICAL CORRIGENDUM 2.
Definition of your table also has a VALUE column, but VALUE is a reserved word in the SQL Standard and it is a keyword in H2. If you cannot rename these columns, you can add `;NON_KEYWORDS=KEY,VALUE` to JDBC URL. It also should have ` ;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE;DEFAULT_NULL_ORDERING=HIGH` if you want a better compatibility with PostgreSQL. Alternatively you can pass these settings in the map with properties. -- 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/7756da35-d074-439e-af77-33adc7a4bbd6n%40googlegroups.com.
