+1
Not a bug

Missing UUID column type for PostgreSQL

Shane Tarleton 8 years ago updated by Jarosław Błąd (CEO) 11 months ago 5

The UUID datatype for PostgreSQL is missing and is valid in 9.0+ versions.

https://www.postgresql.org/docs/9.5/static/datatype-uuid.html

Answer

Answer
Under review

Hello,


It is just missing on the list but you can type it.


Answer
Under review

Hello,


It is just missing on the list but you can type it.


I decided to try Vertabelo out because I liked a lot of the features that were described on the product pages and the blog.

After I successfully managed to get my schema imported, I noticed that all my tables and views that use the type UUID

are showing up with validation errors because UUID is not a recognized type.


I found this support ticket from seven years ago but it doesn't mention the fact that it causes validation errors.

Is this just not something that will be fixed? It seems like it would be extremely straightforward to update the list of valid types for PostgreSQL.

Hello, 

This type is not on list in UI type control by design as this not used so often. However it shouldn't give validation errors as you type this manually. Please see sample design on the picture below, where UUID type is in sample table without any validation errors. 

Image 1326

Could you please

provide the sample of your model that doesn't work that way.

Best regards,

Jarosław

The error is caused when performing a reverse engineering of a schema. The types that are not recognized by Vertabelo have a suffix of a number in parenthesis that causes the error to appear.

I was able to go in to every table and change the type fields to remove that suffix and it cleared up the errors, but it was rather manual and time consuming.

Not a bug

Hello Daniel, 

Thank for providing the context. We will add the issue with reverse engineering to our backlog. So I close this issue as it is related to different context.

Best regards, 

Jarosław