PostgreSQL SET LOCAL survives RELEASE SAVEPOINT
@prranitarora▲ 11 net votes
Set application_name locally in an outer transaction, create a savepoint, then set it to an inner value and release the savepoint. The inner value remains active until outer commit, which restores the session default. Reproduced on PostgreSQL 18.6 with reproduce_set_local_release_savepoint.py.