Re: System views for versions reporting

From: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, Joe Conway <mail(at)joeconway(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: System views for versions reporting
Date: 2025-11-16 16:45:15
Message-ID: vyejydf4qnamuyz4slawjqzuhl3kgzfzgrtruwiuse2v6xitaa@ejvkxapdvqh5
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Tue, Apr 01, 2025 at 09:27:23PM +0200, Dmitry Dolgov wrote:
> > On Sun, Mar 23, 2025 at 06:21:33PM GMT, Tom Lane wrote:
> >
> > FWIW, I think the 0004 patch is about to be mostly obsoleted by
> > Andrei's proposal at [1]. To the extent that it's not obsoleted,
> > I question whether it's something we want at all, given the ground
> > rule that unprivileged users are not supposed to have access to info
> > about the server's filesystem.
>
> To be clear -- I don't have a case for 0004 myself, except some vague
> expectation that in certain situations it could be useful to know which
> shared objects are loaded, even if they are not Postgres modules. Based
> on the feedback from the original thread [2], there were couple similar
> opinions, maybe folks could reply here whether [1] would be sufficient
> for them.

Better late than never, rebased and dropped 0004.

Attachment Content-Type Size
v4-0001-Add-infrastructure-for-pg_system_versions-view.patch text/plain 11.4 KB
v4-0002-Add-core-versions-to-pg_system_versions.patch text/plain 8.3 KB
v4-0003-Add-JIT-provider-version-to-pg_system_versions.patch text/plain 4.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-11-16 17:27:18 Re: Use opresulttype instead of calling SearchSysCache1() in match_orclause_to_indexcol()
Previous Message 河田達也 2025-11-16 16:01:03 [PATCH] Add memory usage reporting to VACUUM VERBOSE