topic Re: postgres primary key int is represented as double in Arcmap in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/postgres-primary-key-int-is-represented-as-double/m-p/826250#M4021 <HTML><HEAD></HEAD><BODY><P>With int(4) it works!</P></BODY></HTML> Fri, 24 Apr 2020 08:57:57 GMT MochiTo 2020-04-24T08:57:57Z postgres primary key int is represented as double in Arcmap https://community.esri.com/t5/geodatabase-questions/postgres-primary-key-int-is-represented-as-double/m-p/826249#M4020 <HTML><HEAD></HEAD><BODY><P>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?<BR />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.<BR />I have attached a picture showing navicat output on the left and the same table in the arcmap feature class properties.</P></BODY></HTML> Fri, 24 Apr 2020 08:33:00 GMT https://community.esri.com/t5/geodatabase-questions/postgres-primary-key-int-is-represented-as-double/m-p/826249#M4020 MochiTo 2020-04-24T08:33:00Z Re: postgres primary key int is represented as double in Arcmap https://community.esri.com/t5/geodatabase-questions/postgres-primary-key-int-is-represented-as-double/m-p/826250#M4021 <HTML><HEAD></HEAD><BODY><P>With int(4) it works!</P></BODY></HTML> Fri, 24 Apr 2020 08:57:57 GMT https://community.esri.com/t5/geodatabase-questions/postgres-primary-key-int-is-represented-as-double/m-p/826250#M4021 MochiTo 2020-04-24T08:57:57Z