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

2022-07-26 Thread Tom Lane
Andrey Lepikhov writes: > On 6/27/22 06:38, Masahiko Sawada wrote: Regarding the patch, I think we can merge makeUniqueTypeName() to makeArrayTypeName() as there is no caller of makeUniqueTypeName() who pass tryOriginal = true. >>> I partially agree with you. But I have one reason

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

2022-06-26 Thread Andrey Lepikhov
On 6/27/22 06:38, Masahiko Sawada wrote: On Fri, Jun 24, 2022 at 2:12 PM Andrey Lepikhov wrote: On 6/23/22 07:03, Masahiko Sawada wrote: > On Sat, Jun 4, 2022 at 4:03 AM Andrey Lepikhov > wrote: >> It is very corner case, of course. But solution is easy and short. So, >> why not to fix

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

2022-06-26 Thread Masahiko Sawada
On Fri, Jun 24, 2022 at 2:12 PM Andrey Lepikhov wrote: > > Moved from the pgsql-bugs mailing list [1]. > > On 6/23/22 07:03, Masahiko Sawada wrote: > > Hi, > > > > On Sat, Jun 4, 2022 at 4:03 AM Andrey Lepikhov > > wrote: > >> > >> According to subj you can try to create many tables (induce

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

2022-06-24 Thread Önder Kalacı
Hi, Thanks for working on this. >> 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