0
Answered

Postgres 15 Needed for CREATE TYPE

naitsabes 2 years ago updated by Jarosław Błąd (CEO) 2 years ago 1

Is seems Vertabelo's Postgres is two version behind. Postgres 15 is required for custom types. When importing scripts that contain CREATE TYPE, model generation is aborted. Also, there is no way to generate models with types that are commonplace in modern Postgres hosing services.

When will Vertabelo support more current versions of Postgres, v15?

Answered

Hello,


This statement is not supported at the moment by design, it is not related to a specific PostgreSQL version.

Adding user defined data types as well as creating domains are on our roadmap. However with no specified time frame. It is a chance that it will be available on the platform by the end of year.

As a workaround you may add to your model custom SQL script that contains CREATE TYPE statements. To do this please use Additional SQL script properties of the model.


Best regards,

Jarosław