On Fri, Feb 2, 2018 at 3:46 AM, Simon Riggs <si...@2ndquadrant.com> wrote: > In PG11, I propose the following command, sticking mostly to Ants' > syntax, and allowing to wait for multiple events before it returns. It > doesn't hold snapshot and will not get cancelled by Hot Standby. > > WAIT FOR event [, event ...] options > > event is > LSN value > TIMESTAMP value > > options > TIMEOUT delay > UNTIL TIMESTAMP timestamp > (we have both, so people don't need to do math, they can use whichever > they have)
WAIT FOR TIMEOUT sounds a lot like SELECT pg_sleep_for(), and WAIT UNTIL TIMESTAMP sounds a lot like SELECT pg_sleep_until(). -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company