Refresh a materialized view concurrently won't work when it's not populated yet. This function tries "concurrently" first and falls back to normal refresh.

safe_refresh_materialized_view_concurrently.sql

CREATE OR REPLACE FUNCTION safe_refresh_materialized_view_concurrently(_name regclass)
RETURNS void AS $$
BEGIN
	EXECUTE 'REFRESH MATERIALIZED VIEW CONCURRENTLY ' || _name;
EXCEPTION
	-- when a materialized view is not populated, concurrently will not work and throw feature_not_supported
	WHEN feature_not_supported THEN
		EXECUTE 'REFRESH MATERIALIZED VIEW ' || _name;
END
$$ LANGUAGE plpgsql;

select safe_refresh_materialized_view_concurrently('some_schema.some_materialized_view'::regclass);