Sometimes materialized views are used to cache a complex query on which a client works. But after client disconnects, the materialized view could be deleted. Regular VIEWs and TABLEs both have support for temporary versions which get automatically dropped at the end of the session. It seems it is easy to add the same thing for materialized views as well. See attached PoC patch.