Re: WIP: System Versioned Temporal Table

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

In response to

Browse pgsql-hackers by date

  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