Postgres module drops value from Output Columns in Options when closing module

[PowerBootWS]

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

1. Insert and connect Postgres module.
2. Use 'select' operation, add column and value as a condition in the Select Rows section.
3. Click Add Option at bottom and select a valid column from the Postgres table.
4. Exit module (with or without testing the step.
5. 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)

[Joffcom]

Hey @PowerBootWS,

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.

{{ ['column_1', 'column_2'] }}

[Joffcom]

Hey @PowerBootWS,

Good news, this was fixed in 1.41.0 in this PR: #9324