Re: WIP: System Versioned Temporal Table - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: WIP: System Versioned Temporal Table
Date
Msg-id CANbhV-Gee8avP652XoNikJrS2chxb9uo4zHujk4MMO1HW221vw@mail.gmail.com
Whole thread Raw
In response to Re: WIP: System Versioned Temporal Table  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: WIP: System Versioned Temporal Table
List pgsql-hackers
On Tue, Jan 26, 2021 at 11:33 AM Vik Fearing <vik@postgresfriends.org> wrote:
>
> On 1/11/21 3:02 PM, Simon Riggs wrote:
> > * UPDATE foo SET start_timestamp = DEFAULT should fail but currently doesn't
>
> I'm still in the weeds of reviewing this patch, but why should this
> fail?  It should not fail.

It should not be possible for the user to change the start or end
timestamp of a system_time time range, by definition.

-- 
Simon Riggs                http://www.EnterpriseDB.com/



pgsql-hackers by date:

Previous
From: Mark Rofail
Date:
Subject: Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Next
From: Guillaume Lelarge
Date:
Subject: Re: Extensions not dumped when --schema is used