public inbox for [email protected]
help / color / mirror / Atom feedFrom: Daniel Westermann <[email protected]>
To: [email protected]
Cc: Surafel Temesgen <[email protected]>
Subject: Re: WIP: System Versioned Temporal Table
Date: Tue, 24 Aug 2021 13:18:34 +0000
Message-ID: <162981111425.22084.8061245050741782223.pgcf@coridan.postgresql.org> (raw)
In-Reply-To: <CANbhV-GeD9PWHMkrZLV2vHASjFk3n2QFhGur6+o1gnAf5wymAg@mail.gmail.com>
References: <CALAY4q-cXCD0r4OybD=w7Hr7F026ZUY6=LMsVPUe6yw_PJpTKQ@mail.gmail.com>
<CANbhV-GeD9PWHMkrZLV2vHASjFk3n2QFhGur6+o1gnAf5wymAg@mail.gmail.com>
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
view thread (97+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: WIP: System Versioned Temporal Table
In-Reply-To: <162981111425.22084.8061245050741782223.pgcf@coridan.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox