'H2 postgresql dialect not working with using keyword

I am trying to cast a text type column in my postgres database to oid type with something like this

ALTER TABLE person ALTER COLUMN id TYPE oid USING id::oid; <--works in postgresql

But we use h2 for our testing with postgresql dialect and it is not liking the using key. If I remove the using keyword the query works in h2 but not in postgres

ALTER TABLE person ALTER COLUMN id TYPE oid; <--works in h2

Questions

  1. Any way I can do this casting in postgresql without using keyword
  2. OR any way I can make h2 recognize using keyword ?
postgresqlh2


Solution 1:[1]

As per this commit looks like support for using keyword was added in following versions

version-2.1.210  version-2.0.206 version-2.0.204 version-2.0.202

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 java_doctor_101

Related Questions