Re: WIP: System Versioned Temporal Table
От | Daniel Westermann |
---|---|
Тема | Re: WIP: System Versioned Temporal Table |
Дата | |
Msg-id | 162981111425.22084.8061245050741782223.pgcf@coridan.postgresql.org обсуждение исходный текст |
Ответ на | Re: WIP: System Versioned Temporal Table (Simon Riggs <simon.riggs@enterprisedb.com>) |
Список | pgsql-hackers |
Hi, quick note: The documentation for this patch mentions: The <literal>starttime</literal> column + will be automatically added to the Primary Key of the table. A quick tests shows that the endtime column is added instead: postgres=# create table t1 ( a int primary key generated always as identity, b text ) with system versioning; CREATE TABLE postgres=# \d t1 Table "public.t1" Column | Type | Collation | Nullable | Default -----------+--------------------------+-----------+----------+------------------------------- a | integer | | not null | generated always as identity b | text | | | starttime | timestamp with time zone | | not null | generated always as row start endtime | timestamp with time zone | | not null | generated always as row end Indexes: "t1_pkey" PRIMARY KEY, btree (a, endtime) Regards Daniel
В списке pgsql-hackers по дате отправления: