[BUG] Postgres Node - Insert boolean default value empty?

When setting the “Values to Send” in a Postgres Node insert, selecting a boolean column from the “Add Column to Send” dropdown adds the selection to the list and appears toggled ON.

One would expect this ON setting to send a ‘true’ value, but the underlying value actually remains empty until toggled or manually set.

n8n

Is this a UI bug?

Information on your n8n setup

  • n8n version: 1.33.1
  • Database: Postgresql
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu 22

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:

Welcome to the community :sun_with_face:
you’re right that the UI is confusing here. I’ll create an internal ticket, thanks for reporting this issue!

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.