[session] enhance session's transaction storage handling to fix cases where commit/rollback is done while in the context of hooks_control/security_enabled managers. Closes #1412648: commit or rollback during postcreate reset hooks control state

sql('DROP FUNCTION IF EXISTS _fsopen(bytea)')
sql('DROP FUNCTION IF EXISTS fspath(bigint, text, text)')