Re: Temporal tables as part of main release

[Paul Jungwirth]

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  ~{:-)
p...@illuminatedcomputing.com

Re: short sql question

[Georg H.]

Hi,

Am 18.06.2021 um 09:15 schrieb goldgraeber-werbetech...@t-online.de:

Hi,

I just cannot see what is wrong with my query:

create table files (id int, name text, prev_name text, );
create table fnchanged (id int, name text);

update files f set prev_name = f.name, name = c.name from fnchanges c where 
f.id = c.id and c.name != f.name


your update statement works for me after changing

from fnchanges

  to

from fnchanged
(as written in your create statement) but I've gotERROR: relation "fnchanges" 
does not exist instead of a syntax error



--- gets syntax error at "from"

(Using PostgreSQL 10.4 on a NAS box)

Best regards
Wolfgang


kind regards
Georg

short sql question

[goldgraeber-werbetechnik]

Hi,

I just cannot see what is wrong with my query:

create table files (id int, name text, prev_name text, );
create table fnchanged (id int, name text);

update files f set prev_name = f.name, name = c.name from fnchanges c where 
f.id = c.id and c.name != f.name

--- gets syntax error at "from"

(Using PostgreSQL 10.4 on a NAS box)

Best regards
Wolfgang