Re: Request to Remove Unused xmin Column from Function Properties Queries

From: Abhinav Patni <abhinavpatni602(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: Request to Remove Unused xmin Column from Function Properties Queries
Date: 2025-07-28 14:00:24
Message-ID: CAJRqHcKbSYUn5=odJav_5M66xosUbgFyrhEF2e5_9iMyXfRjAw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)pgadmin(dot)org> wrote:

> Hi
>
> On Mon, 28 Jul 2025 at 14:46, Abhinav Patni <abhinavpatni602(at)gmail(dot)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
>>
>>
>>
>
> --
> Dave Page
> pgAdmin: https://www.pgadmin.org
> PostgreSQL: https://stream.boxwatch.ru
> pgEdge: https://www.pgedge.com
>
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Bartosz Dmytrak 2025-07-28 20:54:30 Search objects - list of types sort order
Previous Message Dave Page 2025-07-28 13:57:53 Re: Request to Remove Unused xmin Column from Function Properties Queries