061.sql
No OneTemporary
Actions

Size

724 B

Subscribers

None

061.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 60
	-- to_version: 61
	-- description: Drop temporary tables related to entities on commit

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

	CREATE OR REPLACE FUNCTION swh_mktemp_entity_history() RETURNS void
	LANGUAGE sql
	AS $$
	create temporary table tmp_entity_history (
	like entity_history including defaults) on commit drop;
	alter table tmp_entity_history drop column id;
	$$;

	CREATE OR REPLACE FUNCTION swh_mktemp_entity_lister() RETURNS void
	LANGUAGE sql
	AS $$
	create temporary table tmp_entity_lister (
	id bigint,
	lister uuid,
	lister_metadata jsonb
	) on commit drop;
	$$;