How to use custom postgres trigger?

Questions
1

I want to use my custom trigger for postgres

First I tried to create a custom postgres function and trigger, then add the postgres trigger in n8n and enter the channel name, function name and trigger name with replace if exist set to false

But when I try to activate the workflow, it returns the error “There was a problem activating the workflow: “function “stock_availability_update_notify” already exists with same argument types””.

I then tried to first create a postgres trigger and activate it in n8n, and then modify the trigger in postgres

But every time I save the workflow in n8n, it overwrites my changes to the trigger

Information on your n8n setup

  • n8n version: 1.60.1
2

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:
3

Ok, I found the solution,
There is an option in n8n Listen For: Advanced that I overlooked.