EXECUTE format('CREATE TABLE IF NOT EXISTS %s ( CHECK ( customer_name = ''%s'' AND updated_at >= DATE ''%s'' AND updated_at < DATE ''%s'') ) INHERITS (public.process_states)', table_name, customer_name, current__date, next__date);
EXECUTE format('CREATE INDEX %s ON %s %s', index_name_on_pkey, table_name, '(customer_name, process_native_id)'); EXECUTE format('CREATE INDEX %s ON %s %s', index_name_on_process_native_id, table_name, '(process_native_id)');
END IF;
EXECUTE format('INSERT INTO %s SELECT $1.*', table_name) USING NEW; set client_min_messages to NOTICE; RETURN NULL;