Detected enum order is inconsistent

[Denhai]

In the database I'm working with, this part is unstable because it doesn't define ORDER BY:

ARRAY(SELECT enumlabel FROM pg_catalog.pg_enum WHERE enumtypid = t.oid)

alembic-postgresql-enum/alembic_postgresql_enum/get_enum_data.py

Lines 66 to 77 in fa7626e

	sql = """
	SELECT
	pg_catalog.format_type(t.oid, NULL),
	ARRAY(SELECT enumlabel
	FROM pg_catalog.pg_enum
	WHERE enumtypid = t.oid)
	FROM pg_catalog.pg_type t
	LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
	WHERE
	t.typtype = 'e'
	AND n.nspname = :schema
	"""

Examples

SELECT
    enumlabel
FROM
    pg_catalog.pg_enum
WHERE
    enumtypid = 8175864;
         enumlabel
----------------------------
 comment
 findings
 history
 impression_recommendations
 technique

If I include the enumsortorder, it gives a different result:

SELECT
    enumlabel,
    enumsortorder
FROM
    pg_catalog.pg_enum
WHERE
    enumtypid = 8175864
ORDER BY
    enumsortorder;
         enumlabel          | enumsortorder
----------------------------+---------------
 history                    |             1
 technique                  |             2
 findings                   |             3
 comment                    |             4
 impression_recommendations |             5

Performing VACUUM FULL does fix this. I assume that's because it reorganises the underlying postgres structures (ctid)?