Follow-up from "Docs: Add naming conventions to migration style guide"
The following discussion from !60661 (merged) should be addressed:
-
@NikolayS started a discussion: (+2 comments) A good thing to have it documented. I would also mention that there is a limit for identifiers in Postgres, 63 characters – see https://www.postgresql.org/docs/current/limits.html – this is a "soft" limit, so it will not lead to a failure but rather to truncation of index name:
test=# select repeat('a', 64); repeat ------------------------------------------------------------------ aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa (1 row) test=# create index aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa on t1(i); NOTICE: identifier "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" will be truncated to "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" CREATE INDEX