Thread: Fwd: Re: [CORE] temporal tables (SQL2011)

<p>Hi all,<p>are there plans to introduce temporal tables?<p>best,<p>Stefan<br /><div class="moz-forward-container"><br
/><br/> -------- Weitergeleitete Nachricht -------- <table border="0" cellpadding="0" cellspacing="0"
class="moz-email-headers-table"><tbody><tr><thalign="RIGHT" nowrap valign="BASELINE">Betreff: </th><td>Re: [CORE]
temporaltables (SQL2011)</td></tr><tr><th align="RIGHT" nowrap valign="BASELINE">Datum: </th><td>Fri, 4 Nov 2016
10:27:40-0400</td></tr><tr><th align="RIGHT" nowrap valign="BASELINE">Von: </th><td>Peter Eisentraut <a
class="moz-txt-link-rfc2396E"href="mailto:peter_e@gmx.net"><peter_e@gmx.net></a></td></tr><tr><th align="RIGHT"
nowrapvalign="BASELINE">An: </th><td>Stefan Scheid <a class="moz-txt-link-rfc2396E"
href="mailto:ssc@4braincells.de"><ssc@4braincells.de></a></td></tr><tr><thalign="RIGHT" nowrap
valign="BASELINE">Kopie(CC): </th><td><a class="moz-txt-link-abbreviated"
href="mailto:pgsql-core@postgresql.org">pgsql-core@postgresql.org</a></td></tr></tbody></table><br/><br /><pre>On
11/1/1612:08 PM, Stefan Scheid wrote:
 
> how about implementing this feature?
> 
> Want to have a real argument to move 150 customers from mysql to
> postgresql ...
> cause they are not able or willing to use DB2 or Oracle ...

The core team does not coordinate the development effort.  Please write
to pgsql-hackers to discuss development ideas.
</pre></div><br /><div class="moz-signature"><font color="#999999" face="Arial" size="3"><font color="#999999"
size="2"><br/></font> </font></div> 

<div dir="ltr">On Sun, Nov 6, 2016 at 4:08 PM, Stefan Scheid <span dir="ltr"><<a href="mailto:ssc@4braincells.de"
target="_blank">ssc@4braincells.de</a>></span>wrote:<br /><div class="gmail_extra"><div
class="gmail_quote"><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex"><divbgcolor="#FFFFFF" text="#000000"><p>are there plans to introduce temporal tables?<br
/></div></blockquote></div>Idon't know of anyone who is actually working on it, but I agree that it would probably
attractsome users if we did.<br clear="all" /></div><div class="gmail_extra"><br />-- <br /><div
class="gmail_signature"data-smartmail="gmail_signature">Robert Haas<br />EnterpriseDB: <a
href="http://www.enterprisedb.com"target="_blank">http://www.enterprisedb.com</a><br />The Enterprise PostgreSQL
Company</div></div></div>

<div dir="ltr"><p dir="ltr"><p dir="ltr">On 8 Nov. 2016 15:11, "Craig Ringer" <<a
href="mailto:craig@2ndquadrant.com"target="_blank">craig@2ndquadrant.com</a>> wrote:<br /> ><br /> ><br />
><br/> > On 7 November 2016 at 05:08, Stefan Scheid <<a href="mailto:ssc@4braincells.de"
target="_blank">ssc@4braincells.de</a>>wrote:<br /> >><br /> >> Hi all,<br /> >><br /> >>
arethere plans to introduce temporal tables?<br /> ><br /> > I don't know of anybody working on them, but someone
elsemay. Try searching the list archives.<p dir="ltr">I should've mentioned that one of the reasons it doesn't seem to
bethat high on many people's priority lists is that it's fairly easy to implement with triggers and updatable views.
There'sa greater performance cost than I'd expect to pay for the same thing done as a built-in feature, but it works
wellenough.<p>Many ORMs and application frameworks also offer similar capabilities at the application level.<p>So I
thinktemporal tables are one of those nice-to-haves that so far people just find other ways of doing.</div> 

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.