045.sql
-- 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
$$;