syntax error on Windows about periods HOT 3 CLOSED

Hi! You are trying to run the Standard SQL syntax, which PostgreSQL does not understand yet (that's the whole point of this extension). You need to call the functions instead, so your test above would be:

CREATE EXTENSION periods CASCADE;
CREATE TABLE example ( id bigint PRIMARY KEY, value text );
SELECT periods.add_system_time_period( 'example', 'row_start', 'row_end' );
SELECT periods.add_system_versioning( 'example' );

from periods.

Thank you very much!
I feel very stupid. I naively thought a PostgreSQL extension could change SQL overall syntax and thought it was a mistake on my side, not being able of installing the extension properly.

Is the purpose of periods to be a proof of concepts or can it be used in production until temporal tables are fully implemented? (I'm new to PosgreSQL as you may have guessed and I'm evaluating this peculiar standard feature).
Thanks again.

from periods.

I am running PG13 64bit on my Windows 10 system, copied all the (sep'20 release, zip file periods-v1.2-pgREL_12_STABLE-windows-x64.zip) periods related dll and sql files to appropriate folders[lib and share/extension], and restarted the Postgresql13 windows service. Then when I am doing the "create extension" step, the below error is thrown...

NOTICE: installing required extension "btree_gist"
ERROR: could not load library "C:/Program Files/PostgreSQL/13/lib/periods.dll": The specified procedure could not be found.

But the file btree_gist.dll is already present in C:\Program Files\PostgreSQL\13\lib path. Suspecting the path env variable as the problem, I added the C:\Program Files\PostgreSQL\13\lib and 13\share to the system env PATH variable, restarted pg13 service and tried again, same error again :-( .
Edit 1 : So, I launched cmd prompt as administrator, and tried the same, results in same error message. What else could be the problem?
Edit 2 : the copied dll files where by default blocked by Windows OS, so from file Explorer, I unblocked them[requires Admin rights], even after this same error.
Thanks in advance.

Edit 3: compiled the periods using msbuild, and copied that dll to 13/lib folder, and all is working fine. Able to create table and have system versioning. This feature is quite useful, hope it becomes part of the main PGsql release.

from periods.