Re: XID-wraparound hazards in LISTEN/NOTIFY

Bruce Momjian <bruce@momjian.us> writes:
> On Sat, Nov 23, 2019 at 12:10:56PM -0500, Tom Lane wrote:
>>> It suddenly strikes me to worry that we have an XID wraparound hazard
>>> for entries in the notify queue.

> Is this still an open issue?  Should it be a TODO item?

I don't think anyone's done anything about it, so yeah.

Realistically, if you've got NOTIFY messages that are going unread
for long enough to risk XID wraparound, your app is broken.  So
maybe it'd be sufficient to discard messages that are old enough
to approach the wrap horizon.  But still that's code that doesn't
exist.

            regards, tom lane