News for hackers. Stuff that matters.
Re:Easy, alternative soft deletion: `deleted_record_insert` by ttfkam on Sunday January 01, 2023 @11:09AM (#34207447)
Great solution. Unfortunately only works on installations that support extensions, which excludes most managed database services like AWS RDS.

I like how you tried to track the standard as close as possible. I've seen (and written) ad hoc solutions that hard-code too much or mandate certain columns to be present.

That said, unlike the standard and most other RDBMSs, Postgres supports range types. Seems a shame to rely simply on two timestamptz columns when one tstzrange should suffice.

There are no comments on this comment yet.