1. Bitemporal
   1. Roadmap
      1. save for simple tables (no FK)
      2. remove for simple tables (no FK)
      3. foreign keys
      4. system-time stuff
      5. code generator
   2. Points of Interest (POI)

1. TODO bitemporal.diagnostics

   1. TODO list bitemporal tables

   2. TODO list ignored tables with reason

   3. TODO list bitemporal tables missing exclude constraints

2. TODO bitemporal.ignore_tables(regclass): exclude this tables from code generation

3. TODO system-time procedures

4. TODO system-time triggers

5. TODO valid-time triggers

6. TODO valid-time procedures

this type of constraint: exclude using gist(s_id with =, id with =, state with =, valid_period with -|-)

https://www.postgresql.org/docs/current/rangetypes.html

https://www.postgresql.org/docs/current/sql-createfunction.html

• leakproof
• parallel, on non integer ranges it seems we can do parallel functions