Temporal tables as part of main release
I am looking to use the temporal tables feature for keeping track of
changes to my table data. As of now, there is an pgxn.org provided
extension by which we could leverage this functionality, but *when Temporal
tables will become part of the main Postgresql release *[and not as an
extension] ? Even in the Postgresql 14 beta release notes it is not
mentioned.
thanks,
Anand.
On Thursday, June 17, 2021, Anand Sowmithiran <anand.sow@gmail.com> wrote:
I am looking to use the temporal tables feature for keeping track of
changes to my table data. As of now, there is an pgxn.org provided
extension by which we could leverage this functionality, but *when
Temporal tables will become part of the main Postgresql release *[and not
as an extension] ? Even in the Postgresql 14 beta release notes it is not
mentioned.
This email seems to provide a good starting point for reading up on the
past work on the feature.
/messages/by-id/877c5179-d2f6-e222-717f-cc3970ae0d5b@illuminatedcomputing.com
Its already too late for v14 since we are already in beta.
For a feature this complex its probably best to not have expectations of
that nature.
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.
https://commitfest.postgresql.org/33/
David J.
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@illuminatedcomputing.com
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@illuminatedcomputing.com>
wrote:
Show quoted text
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@illuminatedcomputing.com
Anand Sowmithiran <anand.sow@gmail.com> writes:
This is very helpful to know , we can likely count on temporal to be part
of PG 15 !!
You were just told *not* to count on that. Maybe it'll happen,
but I wouldn't take bets on it.
regards, tom lane
Sure, hence I wrote "likely"....!
On Sat, 19 Jun 2021, 8:10 pm Tom Lane, <tgl@sss.pgh.pa.us> wrote:
Show quoted text
Anand Sowmithiran <anand.sow@gmail.com> writes:
This is very helpful to know , we *can* *likely count* on temporal to
be part
of PG 15 !!
You were just told *not* to count on that. Maybe it'll happen,
but I wouldn't take bets on it.regards, tom lane
"Hope" does *not* mean "likely".
On 6/19/21 11:24 AM, Anand Sowmithiran wrote:
Sure, hence I wrote "likely"....!
On Sat, 19 Jun 2021, 8:10 pm Tom Lane, <tgl@sss.pgh.pa.us
<mailto:tgl@sss.pgh.pa.us>> wrote:Anand Sowmithiran <anand.sow@gmail.com <mailto:anand.sow@gmail.com>>
writes:This is very helpful to know , we *_can_* _*likely count*_ on
temporal to be part
of PG 15 !!
You were just told *not* to count on that. Maybe it'll happen,
but I wouldn't take bets on it.regards, tom lane
--
Angular momentum makes the world go 'round.