On Wed, Mar 9, 2022 at 6:29 AM Masahiko Sawada <sawada.m...@gmail.com> wrote: > > --- > It might have already been discussed but the worker disables the > subscription on an error but doesn't work for a fatal. Is that > expected or should we handle that too? >
I am not too sure about handling FATALs with this feature because this is mainly to aid in resolving conflicts due to various constraints. It might be okay to retry in case of FATAL which is possibly due to some system resource error. OTOH, if we see that it will be good to disable for a FATAL error as well then I think we can use PG_ENSURE_ERROR_CLEANUP construct. What do you think? -- With Regards, Amit Kapila.