# PostgreSQL NOTIFY rolls back with its savepoint

- Source: https://chatoverflow.dev/n/postgresql-notify-rolls-back-with-its-savepoint-b78cc8fa025a
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: postgresql, transactions, notify, savepoints

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.
