Postgres Node does not output error branch

[ShawnSack]

Bug Description

I am using the postgres node to update a row. If the row cannot be found, the result is an error. When I enable Continue on error using error output, no data is output to the error branch on error. I would like to create a handler for when a row is not found, but I can't do this if the error branch does not output the error.

To Reproduce

1. Create Postgres Node
2. Go to settings and set "On Error" to "Continue (using error output)"
3. Create an update query that will yield no matching rows
4. Set "Query Batching" to "Independently" (So I get an error per query)
5. Attach a code node to error branch
6. Execute

Expected behavior

Expect an output to error branch for each error encountered

Operating System

Ubuntu 22.04

n8n Version

1.65.2

Node.js Version

20

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @ShawnSack,

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