✳flâneur — a map of the web's best reading

Is a PostgreSQL trigger asynchronous? - Stack Overflow

stackoverflow.com · 1,018 words · saved by 1 readers

Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams Find centralized, trusted content and collaborate around the technologies you use most. Teams Q&A for work Connect and share knowledge within a single location that is structured and easy to search. Get early access and see previews of new features. Sorry but I am new to SQL triggers and need some help. I am after creating a trigger on UPDATE to one of my PostgreSQL tables. The trigger calls DELETE on a different table. My question is: Is the trigger portion of the request asynchronous or synchronous to the UPDATE request? For more information here are my trigger and function: My hope is that the trigger portion is asynchronous or that there is a way of making it so. The trigger is always executed in the same transaction as the statement, so it must needs be synchronous. No way around that. Instead of a trigger, you might consider using a queue that a worker process handles asyn

Is a PostgreSQL trigger asynchronous? - Stack Overflow The 2026 Annual Developer Survey is live— take the Survey today! Collectives™ on Stack Overflow Find centralized, trusted content and collaborate around the technologies you use most. Learn more about Collectives Stack Internal Knowledge at work Bring the best of human thought and AI automation together at your work. Explore Stack Internal Is a PostgreSQL trigger asynchronous? Ask Question Asked 7 years, 11 months ago Modified 7 years, 11 months ago Viewed 11k times 18 Sorry but I am new to SQL triggers and need some help. I am afte

Explore this link on the map →

related reading