@MutedJam regarding the postgres trigger. I just did another experiment using it…
I first went to the db and removed any trace of previous n8n triggers.
Then I ran the postgres trigger on insert event on a specific table.
To my surprise, after pushing the ‘Listen for event’ button it worked and caught when a record was added, so I pushed the button again and waited for it to work. Sadly it did not. I saw how a new record was added to the table with the trigger not reacting to it. I tried stoping the node from listening but it got hung so I reloaded the workflow.
Then i presses the ‘listen for event’ button again. The screen shot attached shows the response I got.
I tried this twice and got the same result.
My Database now has two n8n objects. A trigger on the table and a Trigger function. Will these Stay there even If I never use the trigger node again?
Thanks for your support.
