Re: Temporal tables as part of main release

This is very helpful to know , we can likely count on temporal to be part
of PG 15 !! I would be using Postgresql via Azure cloud[with Citus], so
looking forward to use temporal features in my current development [using
Extension] and then once it is part of PG 15, I guess that would make MSFT
to start supporting pg15 with temporal on their cloud platform too.

thanks,
Anand.

On Fri, Jun 18, 2021 at 11:58 PM Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
wrote:

> On 6/17/21 11:10 PM, David G. Johnston wrote:
> > And, since its not in the commitfest app, and the last emails I found
> > are over a year old, it doesn’t seem to be a priority for anyone at this
> > time.
>
> I'm working on the application-time (aka valid-time) side of this, and
> there is another patch for system-time. I can't speak to that patch, but
> my patch is almost ready to share on the mailing list. I gave a progress
> update at PGCon last month, but here is a summary of what it includes:
>
> - You can define PERIODs (this is based heavily on Vik Fearing's patch
> from a few years ago).
> - You can define temporal PRIMARY KEYs and UNIQUE constraints.
> - You can use FOR PORTION OF syntax to do temporal UPDATEs and DELETEs.
> - You can define temporal FOREIGN KEYs including with all the
> CASCADE/SET NULL/SET DEFAULT options.
>
> I noticed a problem last week with the FOR PORTION OF code, so as soon
> as I fix that I'm going to organize my changes into four patch files
> (one for each of those bullet points) and send that to the list.
>
> So far I haven't tried to support partitioned tables yet, so certainly
> that will remain to be done. But that's the only missing piece I'm aware
> of. (I'd be grateful for any help adding that btw. And Corey has already
> offered to give me some help in general.)
>
> I'm sorry it's been slow progress the last year. I do hope I can get
> this landed for v15!
>
> Yours,
>
> --
> Paul ~{:-)
> pj(at)illuminatedcomputing(dot)com
>
>
>