Changes between Initial Version and Version 1 of Ticket #35956, comment 10
- Timestamp:
- May 30, 2025, 5:00:22 AM (4 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #35956, comment 10
initial v1 3 3 In addition to having composite FKs for multitenancy, there's also the new temporal PK/FK feature in Postgres 18 (currently beta) that will be useful for declaring temporal tables: https://www.depesz.com/2024/10/03/waiting-for-postgresql-18-add-temporal-foreign-key-contraints/ 4 4 5 tl;dr it adds the new `PERIOD` qualifier to FKs for declaring timestamp range constraints , which will likely be used in a composite key alongside the record identifier.5 tl;dr it adds the new `PERIOD` qualifier to FKs for declaring timestamp range constraints (using contains), which will likely be used in a composite key alongside the record identifier. 6 6 7 7 Multitenancy I already use frequently and I anticipate I'll make quite good use of temporal keys :)