@dev I get why you want to give non IT customers this option. It also sounds like an performance, storage nightmare o.O
Would a snapshot based solution be ok, or do you aim for the capability to rollback every single Transaction?
@gom true, we're not planning to offer this to customers, as it would be a nightmare :) Snapshots would be ok, too.
@dev You do not wan't to offer it to customers but clients? I'm a bit confused.
Which kind of access do you want to grant and how easy should it be (maybe describe a workflow?).
Anyway, Postgres omitted "time travel" years ago (storage and performance issues) and recommends using triggers where needed.
Out there are DBS' with time traveling capabilities (Oracle calls it "flashback"), but you likely know that.