Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVrXs-009DH7-1n for pgsql-general@arkaria.postgresql.org; Wed, 17 Dec 2025 13:26:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVrXr-00CvIW-17 for pgsql-general@arkaria.postgresql.org; Wed, 17 Dec 2025 13:26:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVrXq-00CvIN-3D for pgsql-general@lists.postgresql.org; Wed, 17 Dec 2025 13:26:23 +0000 Received: from mail-oo1-xc2c.google.com ([2607:f8b0:4864:20::c2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vVrXq-0019RY-1T for pgsql-general@lists.postgresql.org; Wed, 17 Dec 2025 13:26:22 +0000 Received: by mail-oo1-xc2c.google.com with SMTP id 006d021491bc7-657509d761dso3351686eaf.0 for ; Wed, 17 Dec 2025 05:26:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1765977981; x=1766582781; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Fo/lwaWSxyZ26kS4WvgmrMwukE1EsK0Lcs+n3tEszfU=; b=XwJ7BJn7NSZBuEcqMHDBfkkLnTSoF+GdDL2UmKfrhRMH1tlOLVt+oPgR36hZ2G8U+j +NkrV+M2Rwna5ZhayD1XDrJ+jNp3BRPDT/vmgtV57JAAx+Txh7L26UAsv8JkaUCA0/gY MdaSPdxcEgFXkztAQ2O9hETE8kPIC7niS2RWLpgwaSpfOvC8OyFjndR8fyu9a7FAVcBB KP/oS3soHzmbV2kMEky36jWsSQQ4CzCyL0V+AAQvCHLsdd1VDbBafpybOjjr2nZdQZmD 6dwtObL7PievYbEYExFvhafDdHLjCVWsj47wBUyw1yhb1pA6WGh3pMcn7+eifxLDKQpd Q9Hg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765977981; x=1766582781; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Fo/lwaWSxyZ26kS4WvgmrMwukE1EsK0Lcs+n3tEszfU=; b=fmjM7qOqHUfGV2SnJy3emKzrA8KaGyB8pV/CikNeKzN+zWJzxIJuS4HCaHi53gmtgG NhsJFZfSKNs4lUiHRURxdzBK99fgADV93YI6P3loyXnvXwojd+OEhwfHW/MfXLkBfo5/ +WlFf6BP+ASDyb7CUQA2urHcRmRVFep4m99HuRjay+vPngnzRLpw0JvVj7b7mkrnzQzW klU10fH0oPBOzvHgfIUOTpCnQZQ3Dsq2i/t/Hvzbzl43FUHestl138Kf5/W9zgWJ21x5 ZJQeLiCj2ciFNs7ohTReUb6gNoW5U9i32NTIj+AvypGWldXNKgVuqJY1CA5nPu1XUUGX Mb8w== X-Gm-Message-State: AOJu0YwBhV5Jhu8Ql4A8954gIkZge0VVWAb4F2DDh3rA4JYXSUW+Gcjp Q18FIKX7YZqjEDDFczxVexZ/LhGKCSvkc95AYugegGXSLccsKcRvceGuDGibvwLvt7ZFraqAxKT MvtRA4VEboGt/e8UEK9xNjTCrfnjY2+Y= X-Gm-Gg: AY/fxX7C7kspb+FKvJtDzEJ9z57cw0yF606UlhKtF0BPwHWRjsQL8hct+jLNt9UMeL0 rhNq0okexZoc7fHjZPzgaZYrCUC/2xhHht0md9MuDMJvC36Ks+JHno0eTifw3rQXQr+bSW/I2wP WjxVzPWBskvFm8VLPjkFId5cC369x6gAB2zqyxDO5K2TvomSnOiSJu35DTM1Qyq/O9tjxNqGL48 skAVeO/shxxVoAx7QtO0v2D+V0DdK/2Pp/ZWCBAbcxhvTnjQoD24OaqlgBQSNrsQSZYU0k5D8ap 54RpdyQ= X-Google-Smtp-Source: AGHT+IHvnwVk7cIYyD6672rf00YdjzfegCvhXGb5cqVereQxMBAPK0J91K4biR6MpkBSeo73lQR3DeihVXfIvyaovfA= X-Received: by 2002:a05:6820:a05:b0:659:9a49:8fc0 with SMTP id 006d021491bc7-65b45286d91mr7740162eaf.57.1765977981203; Wed, 17 Dec 2025 05:26:21 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:310b:10b0:610:c294:2f81 with HTTP; Wed, 17 Dec 2025 05:26:20 -0800 (PST) In-Reply-To: <287E4DF6-35A2-4062-AEBA-32DB1DE35C5D@leisi.net> References: <287E4DF6-35A2-4062-AEBA-32DB1DE35C5D@leisi.net> From: "David G. Johnston" Date: Wed, 17 Dec 2025 06:26:20 -0700 X-Gm-Features: AQt7F2qXdSqxEHSoThtiu6h_XUQ52eAd92CC8m3mbIGwXaR2Ufrb8awJo065bNQ Message-ID: Subject: Re: Record last SELECT on a row? To: Matthias Leisi Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000004038c7064625caaa" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004038c7064625caaa Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, December 17, 2025, Matthias Leisi wrote: > > Any other ways this could be achieved? > Without the ability to modify the application which uses a direct database connection, you=E2=80=99d need to modify the server code or run some kind o= f 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. --0000000000004038c7064625caaa Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=99d need to modify the server code or run some kind o= f proxy/man-in-the-middle server you can program.=C2=A0 I would avoid updat= ing the table on write though - just keep a cache of sorts somewhere and pe= riodically compare the cache to the live table.

Da= vid J.

--0000000000004038c7064625caaa--