Saving a workflow with non-existing tag will raise an Error

[barn4k]

Bug Description

If I choose a non-existing tag (don't ask) and try to save a workflow, I will get an error SQLITE_CONSTRAINT: FOREIGN KEY constraint failed for SQLight or insert or update on table "workflows_tags" violates foreign key constraint "fk_workflows_tags_tag_id" for Postgres.

To Reproduce

1. Create any Workflow (just to not mess with the existing workflow tags).
2. Save it
3. Go to the tags section
4. Enter anything new
5. Click on the first dropdown entry
6. Save the workflow or click inside the workflow to loose the focus from tag section

Examples:

Expected behavior

The new tag will be created or there won't be a dropdown entry with the "ghost" tag

Operating System

Cloud / Docker

n8n Version

1.36.1

Node.js Version

docker

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Cheers @barn4k,

I have created ADO-2150 as the internal ticket to resolve this.