public inbox for [email protected]  

help / color / mirror / Atom feed

From: Abhinav Patni <[email protected]>
To: Dave Page <[email protected]>
Cc: [email protected]
Subject: Re: Request to Remove Unused xmin Column from Function Properties Queries
Date: Mon, 28 Jul 2025 19:30:24 +0530
Message-ID: <CAJRqHcKbSYUn5=odJav_5M66xosUbgFyrhEF2e5_9iMyXfRjAw@mail.gmail.com> (raw)
In-Reply-To: <CA+OCxox8fKAwNObF=LeW7b1oA+nLyg3g8MmJ1ftMe-yyqeXNvQ@mail.gmail.com>
References: <CAJRqHcJpf2thrFTw_092nGWAvU3Du9_eXbOOG62U9oBZOUpLgg@mail.gmail.com>
	<CA+OCxox8fKAwNObF=LeW7b1oA+nLyg3g8MmJ1ftMe-yyqeXNvQ@mail.gmail.com>

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 <[email protected]> wrote:

> Hi
>
> On Mon, 28 Jul 2025 at 14:46, Abhinav Patni <[email protected]>
> 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://www.postgresql.org
> pgEdge: https://www.pgedge.com
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Request to Remove Unused xmin Column from Function Properties Queries
  In-Reply-To: <CAJRqHcKbSYUn5=odJav_5M66xosUbgFyrhEF2e5_9iMyXfRjAw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox