n8n-io / n8n

Free and source-available fair-code licensed workflow automation tool. Easily automate tasks across different services.
https://n8n.io
Other
49.29k stars 7.89k forks source link

Postgres Query Parameters not working when use as "Expression" #11835

Open jalvesbsolus opened 1 day ago

jalvesbsolus commented 1 day ago

Bug Description

After update server with n8n (v.1.68.0) the postgres node not execute correctly. If I test print node, received all informações pass from "Query Parameters". Not processed result. Postgres node version 2.3

image

To Reproduce

  1. create node "Postgres" with "Query Paramaters"
  2. Update n8n
  3. Try execute (results not work as espected)

Expected behavior

execute Value inside "Query paramaters"

Operating System

Docker

n8n Version

1.68.0

Node.js Version

v20.18.0

Database

PostgreSQL

Execution mode

main (default)

Joffcom commented 1 day ago

Hey @jalvesbsolus,

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