Postgres do not allow to create many tables with more than 63-symbols prefix

Поиск
Список
Период
Сортировка
От Andrey Lepikhov
Тема Postgres do not allow to create many tables with more than 63-symbols prefix
Дата
Msg-id 121e286f-3796-c9d7-9eab-6fb8e0b9c701@postgrespro.ru
обсуждение исходный текст
Ответы Re: Postgres do not allow to create many tables with more than 63-symbols prefix  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список 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
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: psql 15beta1 does not print notices on the console until transaction completes
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error