03.sql
No OneTemporary
Actions

Size

661 B

Subscribers

None

03.sql
View Options

	-- SWH Scheduler Schema upgrade
	-- from_version: 02
	-- to_version: 03
	-- description: Fix a bug in handling default intervals for task types

	begin;

	insert into dbversion (version, release, description)
	values (3, now(), 'Work In Progress');

	create or replace function swh_scheduler_create_tasks_from_temp ()
	returns setof task
	language plpgsql
	as $$
	begin
	return query
	insert into task (type, arguments, next_run, status, current_interval)
	select type, arguments, next_run, 'next_run_not_scheduled',
	(select default_interval from task_type tt where tt.type = tmp_task.type)
	from tmp_task
	returning task.*;
	end;
	$$;


	commit;