From: | Daniel Westermann <dwe(at)dbi-services(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Cc: | Surafel Temesgen <surafel3000(at)gmail(dot)com> |
Subject: | Re: WIP: System Versioned Temporal Table |
Date: | 2021-08-24 13:18:34 |
Message-ID: | 162981111425.22084.8061245050741782223.pgcf@coridan.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Denis Laxalde | 2021-08-24 14:40:02 | Re: [PATCH] Disable bgworkers during servers start in pg_upgrade |
Previous Message | Justin Pryzby | 2021-08-24 13:13:20 | Re: PoC/WIP: Extended statistics on expressions |