Re: Record last SELECT on a row?

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Matthias Leisi <matthias@leisi.net>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-12-17T13:26:20Z
Lists: pgsql-general
On Wednesday, December 17, 2025, Matthias Leisi <matthias@leisi.net> wrote:
>
> Any other ways this could be achieved?
>

Without the ability to modify the application which uses a direct database
connection, you’d need to modify the server code or run some kind of
proxy/man-in-the-middle server you can program.  I would avoid updating the
table on write though - just keep a cache of sorts somewhere and
periodically compare the cache to the live table.

David J.