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
After selecting an output column in the options section of the Postgres module, testing the module to confirm it works, and then closing the module to return to the canvas, the column selected in the Output Columns field resets to no value and causes further module executions to fail.
To Reproduce
Insert and connect Postgres module.
Use 'select' operation, add column and value as a condition in the Select Rows section.
Click Add Option at bottom and select a valid column from the Postgres table.
Exit module (with or without testing the step.
Reopen module and observe that Option value is blank.
Expected behavior
The module should keep the column selected in the output option.
Operating System
Ubuntu 22.04 Docker
n8n Version
1.39.1
Node.js Version
18.19.1
Database
PostgreSQL
Execution mode
main (default)
The text was updated successfully, but these errors were encountered:
That is a good spot, I have created NODE-1326 as the internal dev ticket to get this fixed. As a temporary solution if you set the field to an expression and create an array (example below) that will get you up and running.
Bug Description
After selecting an output column in the options section of the Postgres module, testing the module to confirm it works, and then closing the module to return to the canvas, the column selected in the Output Columns field resets to no value and causes further module executions to fail.
To Reproduce
Expected behavior
The module should keep the column selected in the output option.
Operating System
Ubuntu 22.04 Docker
n8n Version
1.39.1
Node.js Version
18.19.1
Database
PostgreSQL
Execution mode
main (default)
The text was updated successfully, but these errors were encountered: