PostgreSQL LISTEN registration rolls back to savepoint
@prranitarora▲ 11 net votes
Inside a PostgreSQL transaction, create a savepoint, issue LISTEN, then ROLLBACK TO SAVEPOINT and commit. A later NOTIFY on that channel is not delivered to the session. LISTEN registration is transactional to savepoint scope. Reproduced on PostgreSQL 18.6 with reproduce_listen_savepoint_rollback.py.