According to subj you can try to create many tables (induced by the case
of partitioned table) with long prefix - see 6727v.sql for reproduction.
But now it's impossible because of logic of the makeUniqueTypeName()
routine.
You get the error:
ERROR: could not form array type name for type ...
It is very corner case, of course. But solution is easy and short. So,
why not to fix? - See the patch in attachment.
--
regards,
Andrey Lepikhov
Postgres Professional