Try
Home   >   mailing lists

Re: Request to Remove Unused xmin Column from Function Properties Queries - Mailing list pgadmin-support

From Dave Page
Subject Re: Request to Remove Unused xmin Column from Function Properties Queries
Date
Msg-id CA+OCxox8fKAwNObF=LeW7b1oA+nLyg3g8MmJ1ftMe-yyqeXNvQ@mail.gmail.com
Whole thread Raw
In response to Request to Remove Unused xmin Column from Function Properties Queries  (Abhinav Patni <abhinavpatni602@gmail.com>)
Responses Re: Request to Remove Unused xmin Column from Function Properties Queries
List pgadmin-support
Tree view
Hi

On Mon, 28 Jul 2025 at 14:46, Abhinav Patni <abhinavpatni602@gmail.com> wrote:
Dear pgAdmin Team,

Queries for the xmin system column are causing errors and breaking
function/property dialogs.

What errors or breakage do you see, and in what circumstances? Querying for xmin shouldn't cause any issues on any supported PostgreSQL version, even if it's not used.
 
I see xmin is fetched in property queries
(e.g., functions/templates/*/properties.sql) but is always ignored in
processing, as in:

web/pgadmin/browser/server_groups/servers/databases/schemas/functions/init.py:
keys_to_ignore = ['oid', 'proowner', 'typnsp', 'xmin', …]

Can we drop xmin from these queries? Are there reasons to keep it? If
not, would you accept a patch to remove it?

Thanks,
Abhinav Patni




--

pgadmin-support by date:

Previous
From: Abhinav Patni
Date:
Subject: Request to Remove Unused xmin Column from Function Properties Queries
Next
From: Abhinav Patni
Date:
Subject: Re: Request to Remove Unused xmin Column from Function Properties Queries