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.