Cannot insert data into ArcSDE (postgres)

Just a thought:

Does the Insert involve a binary attribute, where the update and delete do not?

Seen issues with binary attributes in PostGres before.

Hope this helps finding the issue.

@stalknecht Because the error message is from ArcObjects we've got to assume you're using the Esri Geodatabase (ArcSDE) writer. First guess would be to check the permission. PostgreSQL does allow different privaleges for insert/update/delete.

Odd behaviour can occur if you have class extensions installed so check to see if you have any of those in use in your Geodb.

Nope, there are no binary attributes. I've also tried to read one feature from the same table and insert it to it again.

No SDE geometry?

Correct I use the ArcSDE writer. There was a featureclass extension on the dataset. I've removed it to do another test but it didn't solve the issue.

Sorry, yes there is a st_geometry to store the geometry. That's the reason I use the ArcSDE writer.

Excuse me for kicking. Anyone@Safe ?

Hi, I am experiencing the same problem, have you find out how to solve this?

Sorry, I don't remember. The db changed and it was solved. You can check if a FeatureClass-Extension is installed on the db like @Mark Stoakes​  mentioned and check the permissions on the db.