Slight issue in bounce management in PGLister

From: Célestin Matte <celestin(dot)matte(at)cmatte(dot)me>
To: PostgreSQL WWW <pgsql-www(at)lists(dot)postgresql(dot)org>
Subject: Slight issue in bounce management in PGLister
Date: 2025-05-02 17:15:52
Message-ID: c743009d-821b-4ddf-860d-bc6b15b5bc30@cmatte.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

Hello,

I noticed a problem with bounces in PGLister: when an address is newly
added to a list, it is supposed that all former emails were properly
delivered. All prior emails are marked as "Delivered to remote
server", which is not the case as the address was not subscribed yet
(they should not appear at all).

As a result, a bouncing address will not immediately be flagged as a
bounce.

A way to fix that could be to add an "added_date" field to e.g.
list_subscriberaddress.

This may be intentional behaviour as fixing it requires adding a field,
for what is pretty much a corner case (one can expect a newly added
address is not immediately bouncing).
Do you think a fix is worth implementing?

Side-question regarding bounces: I did not find any process in the
codebase that automatically unsubscribes bouncing addresses
(bouncehandler.py leaves this as "run separtely").
Is this expected to always done manually?

Regards,
--
Célestin Matte

Browse pgsql-www by date

  From Date Subject
Next Message Bruce Momjian 2025-05-07 16:21:19 Email verification
Previous Message Célestin Matte 2025-05-02 14:59:39 Re: Making pglister work with exim 4.96+