045.sql
No OneTemporary
Actions

Size

465 B

Subscribers

None

045.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 44
	-- to_version: 45
	-- description: Fixup swh_directory_get for the new directory schema

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

	CREATE OR REPLACE FUNCTION swh_directory_get() RETURNS SETOF directory
	LANGUAGE plpgsql
	AS $$
	begin
	return query
	select d.*
	from tmp_directory t
	inner join directory d on t.id = d.id;
	return;
	end
	$$;

File Metadata

Mime Type: text/plain
Expires: Jul 4 2025, 6:42 PM (5 w, 5 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3283470

Event Timeline