I have made connection to a postgresql database in ArcGIS Catalog from Database connections . pgAdmin shows the database owner is 'postgres' so i have made the connection with user 'postgres'.
I want to further register a table in this database to Geodatabase (to add OID field) which i am not able to do. When I right-click the table and go to Manage, everything is greyed out and not available.
When i use GP tool 'Register with Geodatabase' it gives error –
ERROR 001050 Either registered with geodatabase already or cannot open the dataset.
Documents on ArcGIS resource say – 'Be sure you connect as the owner of the table.'
What does it mean here ? Does it refer to the owner of the database in postgresql or .. ?
Best Answer
As per your questions related to What does it mean here ? Does it refer to the owner of the database in postgresql or .. ?
Based on Can't Register table with Geodatabase - Arc 10.1, SQL 2008
Using ESRI, Fundamentals of ObjectID fields
With some data sources, you can register data with ArcGIS, which adds an ObjectID field.
For reference Warning: Data source does not have an OID field
As a general reference, I would refer to this error information: 001050: Either registered with geodatabase already or cannot open the dataset