Postgres node: insert - Identity column not recognized

[Thomlov81]

Bug Description

Postgres node does not recognize Postgres Identity column as auto_increment ID column.
https://www.postgresql.org/docs/current/ddl-identity-columns.html

This does not work:
create table
public.pl_products (
id bigint generated by default as identity not null,

This works:

CREATE TABLE public.pl_products_example_copy (
id bigint NOT NULL DEFAULT nextval('pl_products_example_copy_id_seq'),

To Reproduce

Create a postgres table using postgres identity column:

create table
public.pl_test (
id bigint generated by default as identity not null
) tablespace pg_default;

Add postgres node in n8n, using insert.

Observe that the column is reported as mandatory, and can't be removed.

Expected behavior

Being able to detelete the column, to let postgres generade the new identity value.

Operating System

Docker

n8n Version

1.71.3

Node.js Version

20.18.0

Database

PostgreSQL

Execution mode

queue

[Joffcom]

Hey @Thomlov81,

We have created an internal ticket to look into this which we will be tracking as "N8N-7976"

[q1LLa]

I have the same problem - https://community.n8n.io/t/bug-in-the-postgres-node-with-manual-mapping/64504/

[coder36]

Have the same issue.