Try
Home   >   mailing lists

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

From Abhinav Patni
Subject Re: Request to Remove Unused xmin Column from Function Properties Queries
Date
Msg-id CAJRqHcKbSYUn5=odJav_5M66xosUbgFyrhEF2e5_9iMyXfRjAw@mail.gmail.com
Whole thread Raw
In response to Re: Request to Remove Unused xmin Column from Function Properties Queries  (Dave Page <dpage@pgadmin.org>)
Responses Re: Request to Remove Unused xmin Column from Function Properties Queries
List pgadmin-support
Tree view
Hi 
I am seeing issues when using aurora postgres limitless. It doesn’t support these columns, for function properties why do we need to query xmin value? Is it supporting some other use case?

On Mon, 28 Jul 2025 at 7:28 PM, Dave Page <dpage@pgadmin.org> wrote:
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: Dave Page
Date:
Subject: Re: Request to Remove Unused xmin Column from Function Properties Queries
Next
From: Bartosz Dmytrak
Date:
Subject: Search objects - list of types sort order