relation "example2__for_portion_of_validity" does not exist

[obelix74]

CREATE TABLE example2 (
    id bigint,
	value text,
    start_date date,
    end_date date,
    CONSTRAINT example2_pkey PRIMARY KEY (id, start_date, end_date)
);

SELECT periods.add_period('example2', 'validity', 'start_date', 'end_date');
SELECT periods.add_unique_key('example2', ARRAY['id'], 'validity', unique_constraint => 'example2_pkey');

insert into example2 values(1, 'one', '2022-01-01', '2022-12-31');
select * from example2;

update example2__for_portion_of_validity
	set value='one one',
	start_date='2022-03-01',
	end_date='2022-05-01'
where id=1;

This fails with:

ERROR:  relation "example2__for_portion_of_validity" does not exist
LINE 1: update example2__for_portion_of_validity
               ^
SQL state: 42P01
Character: 8

Am I doing something wrong?

[posenato]

I met the same issue.

I found that it is possible to add such a view by

select periods.add_for_portion_view('example2','validity');

In the documentation, there are no instructions for issuing such a command.

I am wondering if it is correct to run it explicitly.

Roberto