On 16/02/18 12:38, tushar wrote: > On 02/16/2018 04:02 PM, Petr Jelinek wrote: >> It's because you are creating temporary slot. Temporary slots are >> removed on error, that's a documented behavior. > > Thanks for pointing out but It looks weird behavior - even a small mea > culpa can remove the slot. Temporary table - doesn't go automatically > after an error ? >
Temporary tables have transactional properties, slots don't (even the non-temporary). For example if you create replication slot in transaction and then abort it, the slot will survive. That's the price we pay for ability to create slots on standby. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
