I believe this is a recently introduced bug.
Basically the Postgres Execute-query node fails whenever On Error is set to “Continue (using error output)”. It outputs no results, even when there are results.
This issue began recently so I believe it was introduced with a recent version update.
Describe the problem/error/question
What is the error message (if any)?
Please share your workflow
Information on your n8n setup
- n8n version: latest
- Database (default: SQLite): default
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): npm
- Operating system: linux