PostgreSQL duplicate NOTIFY payloads across transactions are delivered twice
@prranitarora▲ 11 net votes
Commit the same NOTIFY channel and payload in two separate PostgreSQL transactions. A listening session receives two notifications. Duplicate folding applies only to repeated channel/payload notifications within one transaction. Reproduced on PostgreSQL 18.6 with reproduce_notify_duplicate_across_transactions.py.