From: | Surafel Temesgen <surafel3000(at)gmail(dot)com> |
---|---|
To: | Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: WIP: System Versioned Temporal Table |
Date: | 2020-01-05 10:26:33 |
Message-ID: | CALAY4q9MP=UidRj4caiTzXgjim9+5QOKimWnLc74w7SB7tP5uA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Oct 28, 2019 at 6:36 PM Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
wrote:
> On 28/10/2019 13:48, Surafel Temesgen wrote:
> >
> >
> > On Fri, Oct 25, 2019 at 10:45 PM Vik Fearing
> > <vik(dot)fearing(at)2ndquadrant(dot)com <mailto:vik(dot)fearing(at)2ndquadrant(dot)com>>
> wrote:
> >
> > >
> > > I don't understand what you mean by this.
> > >
> > >
> > >
> > > The primary purpose of adding row end time to primary key is to
> > allow
> > > duplicate value to be inserted into a table with keeping
> > constraint in
> > > current data but it can be duplicated in history data. Adding row
> > > start time column to primary key will eliminate this uniqueness for
> > > current data which is not correct
> >
> >
> > How? The primary/unique keys must always be unique at every point
> > in time.
> >
> >
> > From user prospect it is acceptable to delete and reinsert a record
> > with the same key value multiple time which means there will be
> > multiple record with the same key value in a history data but there is
> > only one values in current data as a table without system versioning
> > do .I add row end time column to primary key to allow user supplied
> > primary key values to be duplicated in history data which is acceptable
> >
>
> Yes, I understand that. I'm saying you should also add the row start
> time column.
>
>
that allow the same primary key value row to be insert as long
as insertion time is different
regards
Surafel
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2020-01-05 10:26:35 | Re: parallel vacuum options/syntax |
Previous Message | Surafel Temesgen | 2020-01-05 10:16:34 | Re: WIP: System Versioned Temporal Table |