Select to view content in your preferred language

postgres primary key int is represented as double in Arcmap

402
1
04-24-2020 01:33 AM
MochiTo
New Contributor

It happens to me often, that when I have a table (postgres 11.7, postgis 2.5.3) with an int(8) field with primary key, it is represented as double in the feature class properties. The layers shows fine, but when I receive questions about inputing the objectid column, I cannot use the primary key, because double is out of question. Is there a workaround for this happening?
First it happened to me with a view and I thought that it is just a problem with views, but now I am experiencing the same problem with tables.
I have attached a picture showing navicat output on the left and the same table in the arcmap feature class properties.

Tags (1)
0 Kudos
1 Reply
MochiTo
New Contributor

With int(4) it works!

0 Kudos