n8n's Postgres Node Doesn't Send Parameters. My Dry-Run Did.
The n8n docs for the Postgres node say you can use $1, $2 and $3 in a query "to build prepared statements to use with query parameters." On September 18 I found out what that means in practice, from a failure that my own dry-run had told me couldn't happen. I was running an end-to-end test of a workflow I maintain that books a callback. One Postgres node stores when the callback is due, and the number of minutes comes from earlier in the flow. Sometimes there is no number, so the value is an empty string. Simplified, the node's query looked like this: SELECT CASE WHEN $1 = '' THEN NULL ELSE ma
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in