Re: Fwd: Re: [CORE] temporal tables (SQL2011) - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: Fwd: Re: [CORE] temporal tables (SQL2011)
Date
Msg-id CAMsr+YFXb7-AaLTQq32HqVPvEXiTKUjQpguk9Jr+Q_JqxTcuUw@mail.gmail.com
Whole thread
In response to Re: Fwd: Re: [CORE] temporal tables (SQL2011)  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: Fwd: Re: [CORE] temporal tables (SQL2011)
List pgsql-hackers

On 8 Nov. 2016 15:11, "Craig Ringer" <craig@2ndquadrant.com> wrote:
>
>
>
> On 7 November 2016 at 05:08, Stefan Scheid <ssc@4braincells.de> wrote:
>>
>> Hi all,
>>
>> are there plans to introduce temporal tables?
>
> I don't know of anybody working on them, but someone else may. Try searching the list archives.

I should've mentioned that one of the reasons it doesn't seem to be that high on many people's priority lists is that it's fairly easy to implement with triggers and updatable views. There's a greater performance cost than I'd expect to pay for the same thing done as a built-in feature, but it works well enough.

Many ORMs and application frameworks also offer similar capabilities at the application level.

So I think temporal tables are one of those nice-to-haves that so far people just find other ways of doing.

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Is user_catalog_table sensible for matviews?
Next
From: Jim Nasby
Date:
Subject: Re: Add support for SRF and returning composites to pl/tcl