ERROR
When attempting to create and/or insert new features into a PostgreSQL 12.x or newer Enterprise Geodatabase at version 10.8.1 or newer, the following error is returned:
Failed to create new feature(s). Attribute column not found. Error: column "oid" does not exist
This occurs when:
A significant change to PostgreSQL 12, is the removal of the special behavior of internal OID columns. Tables can no longer be created using the WITH OIDS clause. This forced Esri to make changes to the get_id function which is updated when the geodatabase is upgraded to 10.8.1. It is also part of the reason why PostgreSQL 12 is not supported with ArcGIS 10.8.0 or earlier.
PostgreSQL 12 is only supported as of ArcGIS 10.8.1/ArcGIS Pro 2.6 and creating and/or editing data using ArcGIS Desktop 10.8.0/ArcGIS Pro 2.5 or earlier is not supported once the database is upgraded to PostgreSQL 12, however, in this case, the data is being edited in ArcGIS Desktop 10.8.1/Pro 2.6 but was created while the PostgreSQL version was still at 11 using ArcGIS Desktop 10.8.0/ArcGIS Pro 2.5 which are all compatible versions.
The required get_id functions for the datasets created using ArcGIS Desktop 10.8.0/ArcGIS Pro 2.5 must be updated. There are two options to achieve this, either upgrade the geodatabase to a newer version, or if you are not able to upgrade the geodatabase, use the following workflow to force the upgrade of the geodatabase to execute again:
The upgrade status should now show as 10.8.1 again from both the client application and in the sde.version geodatabase repository table, shown in the next image.
Get help from ArcGIS experts
Download the Esri Support App