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

From: Darren Duncan <darren(at)darrenduncan(dot)net>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: Request to Remove Unused xmin Column from Function Properties Queries
Date: 2025-07-29 10:18:03
Message-ID: b8533b21-4827-4349-8ec4-bfcb26953335@darrenduncan.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 standard features, including foreign
keys, sequences, triggers, exclusion constraints, and mixing DDL and DML in a
common transaction.

Darren Duncan

On 2025-07-29 2:48 a.m., Dave Page wrote:
> 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
> database schemas or clients that work in regular should work with it unmodified.
>
> What are the main differences you see in Aurora that are surfaced to users such
> that they would have any kinds of impact on pgAdmin compatibility?
>
>
> Things related to the underlying storage engine like system columns on tables,
> for example xmin/xmax/ctid which might be different, but there are also a bunch
> of unsupported features (https://docs.aws.amazon.com/aurora-dsql/latest/
> userguide/working-with-postgresql-compatibility-unsupported-features.html), none of which pgAdmin
> knows are unsupported or in what way - e.g. are there system catalogues that are
> missing, will DDL be accepted but do nothing or will it throw errors, will some
> of the catalogues be missing individual columns that may not be needed because
> certain features are unsupported? The list is likely longer than that, but you
> get the gist.
>
> --
> Dave Page
> pgAdmin: https://www.pgadmin.org <https://www.pgadmin.org>
> PostgreSQL: https://stream.boxwatch.ru <https://stream.boxwatch.ru>
> pgEdge: https://www.pgedge.com <https://www.pgedge.com>
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Yogesh Mahajan 2025-07-29 11:02:51 Re: Problem using new installation
Previous Message Dave Page 2025-07-29 09:48:07 Re: Request to Remove Unused xmin Column from Function Properties Queries