Hi,
I attempting to write to an existing table which contains polygons based in Postgres database. I have selected truncate existing table.
I get following error:
Error was 'ERROR: null value in column "objectid" violates not-null constraint
The object ID seems to be an issue only when attempting remove existing data and add new data. When creating a new table, this is not a issue.
Best answer by tomf
It sounds like the Postgresql table has a non-null constraint on the objectid field (There's no ESRI SDE sitting on top of this DB is there?). You will have to ensure that all features you write contain a value for objectid (or edit the table definition to remove the constraint). Also, check your writer feature type parameters don't assign an index to objectid.
Creating a new table won't automatically have this constraint, so you don't run into this issue.
+14It sounds like the Postgresql table has a non-null constraint on the objectid field (There's no ESRI SDE sitting on top of this DB is there?). You will have to ensure that all features you write contain a value for objectid (or edit the table definition to remove the constraint). Also, check your writer feature type parameters don't assign an index to objectid.
Creating a new table won't automatically have this constraint, so you don't run into this issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
