Question

Postgres triggers are not addressed

  • 31 October 2023
  • 4 replies
  • 39 views

Userlevel 1
Badge

Hello all, 
I have a problem regarding my postgres zaps. I have various zaps that should be triggered when a new row is added to my Postgres database or when an existing row is revised there. However, these do not trigger. I add the data via Python to my Postgres database running on AWS and monitor it with DBeaver. Both inserting and revising records works, it's just the zaps that don't trigger. 
Specifically, I use "New Row in PostgreSQL" and "New or Updated Row in PostgreSQL" as triggers.
Does anyone know what the problem could be? I would be grateful for any help. :)

 

 


4 replies

Userlevel 7
Badge +14

Hi @anajana 

Good question.

All the PostgreSQL Zap triggers are scheduled, meaning those can take from 1-15 minutes to fire depending on your Zapier plan.

Check your Zap Runs for activity/issues: https://zapier.com/app/history/

 

Userlevel 1
Badge

Thank you! Good to know that they’re scheduled! :)

However, several hours have passed since I carried out the actions on my PostgreSQL-database and I still don't see a run on any of the zaps. 

 

Userlevel 7
Badge +14

@anajana 

Have you reviewed these help articles?

https://zapier.com/apps/postgresql/help

Userlevel 1
Badge

@Troy Tessalone 

Yes, I have already read the pages, but I only ever update individual dates, so I don't think I have the error mentioned there.

Reply