Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Dunstan
Subject Re: WIP: System Versioned Temporal Table
Date
Msg-id 7497595e-e656-11f2-d183-e03d3affed5f@dunslane.net
Whole thread Raw
In response to Re: WIP: System Versioned Temporal Table  (Simon Riggs <simon.riggs@enterprisedb.com>)
Responses Re: WIP: System Versioned Temporal Table  (Surafel Temesgen <surafel3000@gmail.com>)
List pgsql-hackers
Tree view 
On 1/8/21 7:33 AM, Simon Riggs wrote:
>
> * What happens if you ask for a future time?
> It will give an inconsistent result as it scans, so we should refuse a
> query for time > current_timestamp.


That seems like a significant limitation. Can we fix it instead of
refusing the query?


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: [PATCH] Simple progress reporting for COPY command
Next
From: David Steele
Date:
Subject: Re: data_checksums enabled by default (was: Move --data-checksums to common options in initdb --help)