Re: SQL:2011 application time - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: SQL:2011 application time
Date
Msg-id CADkLM=cDpJ=Q_wVgsG3MxB4PRKcprnoJ_zJuAWCpxA-pyj88dQ@mail.gmail.com
Whole thread Raw
In response to Re: SQL:2011 application time  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-hackers

 But
the standard says that dropping system versioning should automatically
drop all historical records (2 under Part 2: Foundation, 11.30 <drop
system versioning clause>). That actually makes sense though: when you
do DML we automatically update the start/end columns, but we don't
save copies of the previous data (and incidentally the end column will
always be the max value.)

This is what I was referring to when I mentioned a side-table. deleting history would be an O(1) operation. Any other misunderstandings are all mine.


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: pl/pgsql feature request: shorthand for argument and local variable references
Next
From: "Joel Jacobson"
Date:
Subject: Re: pl/pgsql feature request: shorthand for argument and local variable references