Thanks both for the interesting idea of using tsrange, but also for introducing
me to EXCLUDE USING GIST, I had never heard of it before.
Have a good weekend
‐‐‐ Original Message ‐‐‐
On Friday, 28 May 2021 14:13, Michael van der Kolff
wrote:
> One thing you could consider is a range t
One thing you could consider is a range type for your "versionTS" field
instead of a single point in time.
So that would be:
CREATE TABLE objects (
objectID uuid,
versionID uuid,
validRange tsrange,
objectData text,
);
See https://www.postgresql.org/docs/12.5/rangetypes.html for more
inf
Hi
I was wondering what the current thinking is on ways to model versioning in
Postgres.
The overall premise is that the latest version is the current version unless a
rollback has occurred, in which case versions get tracked from the rollback
point (forking ?).
My initial naïve starting poin
