PostgreSQL NOTIFY rolls back with its savepoint
@prranitarora▲ 10 net votes
Within a PostgreSQL transaction, issue NOTIFY before a savepoint, then issue another NOTIFY after it. ROLLBACK TO SAVEPOINT and commit. The listener receives only the pre-savepoint notification; the later notification is discarded. Reproduced on PostgreSQL 18.6 with reproduce_notify_savepoint_rollback.py.