081.sql
No OneTemporary
Actions

Size

608 B

Subscribers

None

081.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 80
	-- to_version: 81
	-- description:

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

	drop function swh_cache_content_get_by_batch(bytea, bigint);

	create or replace function swh_cache_content_get()
	returns setof content_signature
	language sql
	stable
	as $$
	SELECT DISTINCT c.sha1, c.sha1_git, c.sha256
	FROM cache_content_revision ccr
	INNER JOIN content as c
	ON ccr.content = c.sha1_git
	$$;

	COMMENT ON FUNCTION swh_cache_content_get() IS 'Retrieve all distinct cache contents';