Unable to Edit PostgreSQL Layers in ArcGIS Pro – Only Views Are Added

wasfymohammed

Hello everyone,

I'm facing an issue when connecting my PostgreSQL database to ArcGIS Pro. I am using a user with superuser privileges, so I have full access to the database and its contents, including editing rights.

However, after I successfully add the database connection and drag layers into ArcGIS Pro, the layers appear as read-only views. I am unable to edit the features or create new ones using the "Create Features" tool.

I'm wondering why this happens. Given that I have superuser privileges, shouldn't I be able to edit the layers directly?

Has anyone faced this issue before? Any suggestions or workarounds would be greatly appreciated.

Thanks in advance!

George_Thompson

Is the PostgreSQL DB an "Enterprise Geodatabase" (with SDE schema)?

If not, you cannot edit the data directly in a database (non-geo): https://pro.arcgis.com/en/pro-app/latest/help/data/databases/databases-and-arcgis.htm#ESRI_SECTION1_A188C2B1C8C54C7DA3233892FC742552

https://esriaustraliatechblog.wordpress.com/2023/02/12/can-i-edit-data-in-a-database-not-enabled-as-a-geodatabase-from-arcgis-pro/

Hope this helps!