RE: Re: Logging the feature of SQL-level read/write commits

Hi Legrand & Bruce, Thanks for your  thoughts. I think MariaDB's temporal queries could work.  If I want to use it in PostgreSQL, I could use Logical Decoding plugins for recording all INSERT/UPDATE/DELETE history of each table: - https://debezium.io/docs/install/postgres-plugins/ - wal2json

Logging the feature of SQL-level read/write commits

Hi,I am trying to efficiently rollback a manually selectedd subset of committed SQL transactions by scanning an SQL transaction log. This feature is useful when a database administrator wants to rollback not the entire database system, but only particular SQL statements that affect a certai