Fix PostgreSQL long-identifier truncation warnings
Table of Contents
This page is a capture in the next bucket of the product backlog — a pre-sprint idea, not yet pulled into a sprint as a story.
What
(One paragraph: the idea.)
Why
(Motivation, problem being solved, related context.)
References
See also
PostgreSQL silently truncates identifiers longer than NAMEDATALEN (63 bytes by default). Database setup currently logs many truncation warnings including:
dq_lei_relationships_artefact_relationship_start_node_node_id_idx→ truncatedores_refdata_party_contact_informations_party_contact_type_uniq_idx→ truncatedores_refdata_counterparty_contact_informations_counterparty_contact_type_uniq→ truncated
Truncated index names can cause silent collisions. Shorten all offending names to ≤ 63 bytes. Apply a naming convention to prevent recurrence (e.g. use abbreviated table-prefix + column abbreviation + suffix).