Postgres do not allow to create many tables with more than 63-symbols prefix - Mailing list pgsql-bugs

From Andrey Lepikhov
Subject Postgres do not allow to create many tables with more than 63-symbols prefix
Date
Msg-id 121e286f-3796-c9d7-9eab-6fb8e0b9c701@postgrespro.ru
Whole thread Raw
Responses Re: Postgres do not allow to create many tables with more than 63-symbols prefix  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-bugs
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
Attachment

pgsql-bugs by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: psql 15beta1 does not print notices on the console until transaction completes
Next
From: Michael Paquier
Date:
Subject: Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error