| From: | Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> |
|---|---|
| To: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Cc: | d(dot)koval(at)postgrespro(dot)ru |
| Subject: | Postgres do not allow to create many tables with more than 63-symbols prefix |
| Date: | 2022-06-03 19:02:56 |
| Message-ID: | 121e286f-3796-c9d7-9eab-6fb8e0b9c701@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| 6727v.sql | application/sql | 397 bytes |
| 0001-Allow-postgresql-to-generate-more-relations-with-the.patch | text/plain | 3.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2022-06-06 02:15:44 | Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error |
| Previous Message | Fabien COELHO | 2022-06-03 18:25:23 | Re: psql 15beta1 does not print notices on the console until transaction completes |