src/bin/gp_session_state/uninstall_gp_session_state.sql

SET search_path = session_state;

BEGIN;

DROP VIEW session_state_memory_entries; 
DROP FUNCTION session_state_memory_entries_f();
DROP SCHEMA session_state;

COMMIT;