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

2025-07-29 Thread Abhinav Patni
Hi Dave, Thanks for your prompt response and for clarifying the situation. I appreciate your guidance! For this particular use case, I'll move forward with the fix as discussed. If I encounter other incompatibilities, I'll reach out or look into them further. Thanks again! On Tue, Jul 29, 2025 a

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

2025-07-29 Thread Darren Duncan
So it looks like there are at least 2 distinct versions of Postgres-compatible Amazon Aurora. The regular Aurora would have all the regular Postgres features I suppose. While the one you linked to is a specialized Distributed or DSQL variant and I see it is actually missing a huge amount of st

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

2025-07-29 Thread Dave Page
On Tue, 29 Jul 2025 at 10:24, Darren Duncan wrote: > I had understood that Aurora mainly differed with its lower level > internals > implementation, but that it should look the same from a user perspective > and > thus be drop-in compatible with regular Postgres in practice, such that > any > dat

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

2025-07-29 Thread Darren Duncan
I had understood that Aurora mainly differed with its lower level internals implementation, but that it should look the same from a user perspective and thus be drop-in compatible with regular Postgres in practice, such that any database schemas or clients that work in regular should work with i

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

2025-07-29 Thread Dave Page
Hi On Mon, 28 Jul 2025 at 15:00, Abhinav Patni wrote: > 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? > Aurora isn't something we support, as i

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

2025-07-28 Thread Abhinav Patni
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 wrote: > Hi > > On Mon, 28 Jul 2025 at 14:46, Abhinav Patni >

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

2025-07-28 Thread Dave Page
Hi On Mon, 28 Jul 2025 at 14:46, Abhinav Patni 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 supp

Request to Remove Unused xmin Column from Function Properties Queries

2025-07-28 Thread Abhinav Patni
Dear pgAdmin Team, Queries for the xmin system column are causing errors and breaking function/property dialogs. 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/s