AnsweredAssumed Answered

postgres primary key int is represented as double in Arcmap

Question asked by on Apr 24, 2020
Latest reply on Apr 24, 2020 by

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.