public inbox for [email protected]  

help / color / mirror / Atom feed

From: Greg Sabino Mullane <[email protected]>
To: Matthias Leisi <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Record last SELECT on a row?
Date: Wed, 17 Dec 2025 07:42:41 -0500
Message-ID: <CAKAnmmK_9NaPeDtpfyJu7_TtLbEEPmMQGL9GLUQgB8cSZsLadA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Wed, Dec 17, 2025 at 2:41 AM Matthias Leisi <[email protected]> wrote:

> The table contains some ten thousand rows, five columns, and we already
> record created / last updated using triggers.

 ...

> Any other ways this could be achieved?
>

It depends a lot on how the table is accessed, but you could use a function
(or group of functions) that returns the information from the table, and
along the way, updates the requested metadata.


Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Record last SELECT on a row?
  In-Reply-To: <CAKAnmmK_9NaPeDtpfyJu7_TtLbEEPmMQGL9GLUQgB8cSZsLadA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox