Partitioning Apache AGE Vertex Tables Fails Due to graphid Data Type Limitations

[SoumitraBhandary]

Issue Description

While attempting to implement PostgreSQL native table partitioning on Apache AGE vertex tables, we encountered functional limitations related to the graphid data type. Apache AGE internally uses graphid (an AGE-specific type) for vertex and edge identifiers. This data type introduces constraints that prevent direct and safe use of native PostgreSQL partitioning strategies.

Specifically, attempts to partition AGE-managed vertex tables using graphid as the partition key resulted in errors, unsupported behavior, or non-deterministic query execution.

⸻

Environment
• PostgreSQL Version: 15.x / 16.x
• Apache AGE Version: 1.5.x (and earlier)
• Partitioning Type Attempted: RANGE / HASH
• Table Type: AGE vertex tables (ag_catalog.vertex)

[jrgemignani]

@SoumitraBhandary Could you give an example or two showing your issue? Also, graphid is actually an int64 that is typecast to be a graphid, if that helpful -

typedef int64 graphid;