This is a known limitation on Postgresql connector:

Insert row operation requires to provide explicit value for Primary Key column, even though default/autoincrement value is defined.

see https://learn.microsoft.com/en-us/connectors/postgresql/#known-issues-and-limitations for more details