Re: Record last SELECT on a row?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Matthias Leisi <matthias(at)leisi(dot)net>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Record last SELECT on a row?
Date: 2025-12-17 13:26:20
Message-ID: CAKFQuwbo1oHLXVYGS1pTpXpXxsmZSV63xgvmSvR-9HRRN-rgBQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, December 17, 2025, Matthias Leisi <matthias(at)leisi(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Colin 't Hart 2025-12-17 15:13:37 wal segment size
Previous Message Greg Sabino Mullane 2025-12-17 12:42:41 Re: Record last SELECT on a row?