I’m trying to figure out how a Postgres Trigger should work.
I don’t understand why it’s not being triggered.
I set the trigger to activate when a new row appears in the “Test” table, but it’s not triggering.
my db= super base
what do i need to do to make it work ?
The Postgres trigger uses polling. It doesn’t react to events from the database (that would work with Postgres triggers and N8N webhooks), but instead it checks regularly if there are new rows in the table.
When you run the trigger with the test workflow, it keeps sending SELECT queries and waits for new entries. So, click Test Workflow directly on the Postgres trigger, then do an insert. It’s also a good idea to pin the data (see example). The data from the new entry will then be available in payload.
Oh, okay, thanks! Now I understand.
But even when I click “Test Workflow” and manually insert a new row, nothing happens—it’s not triggering.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
