AnsweredAssumed Answered

postgres primary key int is represented as double in Arcmap

Question asked by mochalko@gmail.com on Apr 24, 2020
Latest reply on Apr 24, 2020 by mochalko@gmail.com

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.

Attachments

Outcomes