Null values when appending to PostgreSQL

[BTreeTech]

I am appending features to a PostreSQL table/ Postgis layer.

• If I append using the "Just append all features...." option - all is fine
• If I append using the "if a duplicate is found UPDATE...." option and there is a duplicate - all is fine
• If I append using the "if a duplicate is found UPDATE...." option and there is not a duplicate I get an error when it tries to add the feature. The error is ERROR: null value in column "uuid" of relation "MyLayer" violates not-null constraint - since there is a uuid for each feature I assume something else is happening.

[gacarrillor]

Thanks for reporting.
Could you perhaps share the DDL of your target table?

[BTreeTech]

Thanks for reporting. Could you perhaps share the DDL of your target table?

Do you mean publicly share the connection details for the database?

[gacarrillor]

@BTreeTech, just the table structure (e.g., in SQL).
Optionally, that could include sample data, just in case it's not sensible data.

[gacarrillor]

Got it internally. Leaving it here for reference.

CREATE TABLE IF NOT EXISTS myschema.mylayer
(
    geom geometry(Polygon,3857),
    uuid character varying NOT NULL,
    user_name character varying,
    num_stuff bigint,
    georef_required boolean,
    CONSTRAINT "mylayer_pkey" PRIMARY KEY (uuid)
)