doc: Add section for temporal tables
authorPeter Eisentraut <[email protected]>
Wed, 5 Nov 2025 15:38:04 +0000 (16:38 +0100)
committerPeter Eisentraut <[email protected]>
Wed, 5 Nov 2025 15:38:04 +0000 (16:38 +0100)
commite4d8a2af07f56ec2537eb8f9a16599249db62c94
tree2045372146786da79d71663b7c2195098ec1789f
parent447aae13b0305780e87cac7b0dd669db6fab3d9d
doc: Add section for temporal tables

This section introduces temporal tables, with a focus on Application
Time (which we support) and only a brief mention of System Time (which
we don't).  It covers temporal primary keys, unique constraints, and
temporal foreign keys.  We will document temporal update/delete and
periods as we add those features.

This commit also adds glossary entries for temporal table, application
time, and system time.

Author: Paul A. Jungwirth <[email protected]>
Discussion: https://www.postgresql.org/message-id/flat/ec498c3d-5f2b-48ec-b989-5561c8aa2024@illuminatedcomputing.com
doc/src/sgml/ddl.sgml
doc/src/sgml/glossary.sgml
doc/src/sgml/images/Makefile
doc/src/sgml/images/temporal-entities.svg [new file with mode: 0644]
doc/src/sgml/images/temporal-entities.txt [new file with mode: 0644]
doc/src/sgml/images/temporal-references.svg [new file with mode: 0644]
doc/src/sgml/images/temporal-references.txt [new file with mode: 0644]