Unknown data type: "TINYINT"

204 views
Skip to first unread message

lgur...@gmail.com

unread,
Mar 19, 2018, 5:16:09 PM3/19/18
to H2 Database

Andrei Tokar

unread,
Mar 19, 2018, 10:47:40 PM3/19/18
to H2 Database
Does it work for you if CREATE statement is executed directly from web console?
I was not able to reproduce it.

Evgenij Ryazanov

unread,
Mar 19, 2018, 11:39:14 PM3/19/18
to H2 Database
TINYINT is disallowed in PostgreSQL mode since 1.4.197 because PostgreSQL does not have such data type. The smallest integer data type in PostgreSQL is smallint.


So you should either use normal mode instead of PostgreSQL one or use only data types that are supported by PostgreSQL if you need this mode.

lgur...@gmail.com

unread,
Mar 20, 2018, 3:20:18 PM3/20/18
to H2 Database
Thanks, Evgenij!

It makes sense now.
Reply all
Reply to author
Forward
0 new messages