From the extension readme:<p>> Currently, Temporal Tables Extension supports the system-period temporal tables only.<p>For anyone looking for full application-period support and bitemporal tables on Postgres, I think the only actively maintained library/extension available is <a href="https://github.com/hettie-d/pg_bitemporal">https://github.com/hettie-d/pg_bitemporal</a> (it's also not SQL:2011 compliant though).