Bug - Postgres v2.5 query parameters comma issue

Questions
,
1

Describe the problem/error/question

When having a:

  • Postgres Node v2.5
  • Calling a query, with query parameters
    Then if one of the input has commas it will split the input in several parts (even with single quote around, and with the toggle option ON)

Ex: ‘MON, 21, 2023’ as $1, will be split into $1:‘MON’, $2:’ 21’, $3: ’ 2023’

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3
  • n8n version: [email protected]
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): cloud
  • Operating system: mac
4

(Duplicate I guess of this bug report: Postgres Query Parameters ... bug?)

5

Hi @Kevin_Lourd1

Thanks for reporting this!
We will have a look internally and post an update here :pray:

1 Like