Capitalised role throws error on add_system_versioning about periods HOT 7 OPEN

Hi and thanks for the report!

I have fixed this locally and will push a new version after I make sure there are no other issues like this one.

from periods.

Do you know when you can push the new version?

I really like the extension but have the same problem with capitalized roles.

from periods.

I believe I have found a regression or recurrence of this problem. The table I am trying to add versioning to is called "tabToDo":

SELECT periods.add_period("tabToDo", 'validity', 'creation', 'valid_to');

ERROR:  column "tabToDo" does not exist
LINE 1: SELECT periods.add_period("tabToDo", 'validity', 'creation',...

from periods.

You need to use single quotes.

from periods.

Using single quotes automatically de-capitalizes the input. The table name is case sensitive: "tabToDo".

SELECT periods.add_period('tabToDo', 'validity', 'creation', 'valid_to');
ERROR:  relation "tabtodo" does not exist
LINE 1: SELECT periods.add_period('tabToDo', 'validity', 'creation',...

from periods.

'"tabToDo"'

from periods.

Ah! Success. Thank you.

SELECT periods.add_period('"tabToDo"', 'validity', 'creation', 'valid_to');
 add_period
------------
 t
(1 row)

from periods.