Unable to specify Array of bigint as data type

PostgreSQL - related issues
Post Reply
tchen99_98
Posts: 5
Joined: Thu Oct 19, 2017 2:20 pm

Unable to specify Array of bigint as data type

Post by tchen99_98 » Thu Oct 19, 2017 2:52 pm

Hello,

I am using DbSchema 7.6.3.; my DB is PostgreSQL 9.6.3

I need to add a column with data type as Array of Big Integer (bigint []) and I don't seem to see that in the dropdown list as a choice of Data Type when adding new column. On the other hand, "smallint []" and "integer []" are available as data type.

Does anyone know how to get around this?

thanks

tie ju

tchen99_98
Posts: 5
Joined: Thu Oct 19, 2017 2:20 pm

Re: Unable to specify Array of bigint as data type

Post by tchen99_98 » Thu Oct 19, 2017 3:52 pm

Found the solution by adding "bigint[]" as new data type:

Edit---> Rdbms, Data types, Settting ---> Data Types --> New

then add "bigint[]" as Array

support
Posts: 65
Joined: Tue Dec 01, 2015 8:44 am

Re: Unable to specify Array of bigint as data type

Post by support » Fri Oct 27, 2017 7:33 am

We added this also in the latest DbSchema version.

Post Reply