Postgres Module error when updating other columns in row with array column

[leesilverman]

Bug Description

Postgres Module in Update mode. Table has a column of type jsonb[] that is set to not null. Module throws error 'Column 'XXX' has to be an array' when updating other columns, even if that column has been deleted from Values to update. Correct behavior is that the module should not check the type of data supplied for that field because we're not updating that field.

To Reproduce

1. Create a table with three columns: id (int, not null, primary key, identity always), userdata (array of jsonb), updated (timestamptz, not null)
2. In automation, create Postgres module with Insert operation to add a row with an array of JSON objects as the userdata and {{ $now }} as the value for updated
3. Connect a Postgres module with Update operation that matches on id. Use {{ $json.recno }} from the previous module as the value to match on. Use {{ $now }} for updated. Click the trash icon next to column userdata.

The update module should throw an error saying that userdata needs to be an array.

Expected behavior

Should not error because we're not updating the userdata column.

Operating System

Amazon Linux 2023

n8n Version

1.80.5

Node.js Version

22

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @leesilverman,

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