You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Closing this is ridiculous, please fix it, as you can't use the Postgres node properly right now with this error.
It needs weird workarounds, editing the text to remove the commas.. this is not the way it should be.
To Reproduce
Configure a Postgres node for the Execute Query operation.
Set the Query to use multiple parameters, e.g.: INSERT INTO your_table (text_col, timestamp_col) VALUES ($1, $2);
In the node "Options", add the "Query Parameters" field.
Enter an expression that evaluates to a comma-separated string where the first value contains a comma, e.g.:
The node should correctly parse the comma-separated string provided in the "Query Parameters" field. It should assign the full string "Text data, with a comma" to $1 and the string "2025-01-01T12:00:00Z" to $2, allowing the parameterised query to execute successfully against the database.
Operating System
Ubuntu Linux
n8n Version
1.97.1
Node.js Version
v20.19.0
Database
PostgreSQL
Execution mode
main (default)
The text was updated successfully, but these errors were encountered:
DimaUndSo
changed the title
Query Parameters break when a text parameter includes a comma
Postgres Query Parameters break when a text parameter includes a comma
Jun 15, 2025
Uh oh!
There was an error while loading. Please reload this page.
Bug Description
I refer here to the same issue that was already "Closed as not planned":
https://github.com/n8n-io/n8n/issues/14955
Closing this is ridiculous, please fix it, as you can't use the Postgres node properly right now with this error.
It needs weird workarounds, editing the text to remove the commas.. this is not the way it should be.
To Reproduce
Expected behavior
The node should correctly parse the comma-separated string provided in the "Query Parameters" field. It should assign the full string "Text data, with a comma" to $1 and the string "2025-01-01T12:00:00Z" to $2, allowing the parameterised query to execute successfully against the database.
Operating System
Ubuntu Linux
n8n Version
1.97.1
Node.js Version
v20.19.0
Database
PostgreSQL
Execution mode
main (default)
The text was updated successfully, but these errors were encountered: