LANGUAGE plpgsql

    AS $$

DECLARE

	temp_table_esc text = util.concat_esc(table_esc, '__new');

		-- _ not . to avoid requiring "" around name

	temp_table regclass;

	temp_table_mod_sql text = util.identifier_replace(table_esc, temp_table_esc,

		table_mod_sql);

BEGIN

	IF repopulate THEN 

		/* test if recreate() can successfully re-create the dependent views, to

		avoid populating the entire table (which for some views can take hours)

		only to have the changes rolled back by a failing dependent view */

		BEGIN

			PERFORM util.rematerialize_view(table_esc, view_, table_mod_sql,

				repopulate := false);

			-- roll back DB changes

			PERFORM util.raise('ROLBK', 'sandbox block finished and rolled back');

		EXCEPTION

		WHEN SQLSTATE 'ROLBK' THEN NULL;

		END;

	END IF;

	-- create new table, without blocking original table

	PERFORM util.copy_struct(view_, temp_table_esc);

	temp_table = temp_table_esc::regclass; -- once it exists

	PERFORM util.eval(temp_table_mod_sql);

	PERFORM CASE WHEN repopulate THEN util.copy_data(view_, temp_table) END;

	-- move new table into place (fast operation)

	PERFORM util.relation_replace(table_esc, temp_table);

END;

$$;

non-blocking: allows full access to original materialized table during operation