| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Arup Nanda <Arup(dot)Nanda(at)protonmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: gist segmentation fault |
| Date: | 2022-04-04 14:12:06 |
| Message-ID: | 1886767.1649081526@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Arup Nanda <Arup(dot)Nanda(at)protonmail(dot)com> writes:
> We're preparing to upgrade postgresql from 12.8 to 14.2 but still we have some bugs and issues. Most of them are our fault, but now we have problem wedon't know how to play with it.
> [ crash in copy_ltree for an upgraded GIST index ]
I think this is the same problem already reported at [1].
It's an unfortunate error in the GIST ltree opclass.
You could apply the patch [2] locally perhaps, if you
don't want to wait around for 14.3.
regards, tom lane
[1] https://www.postgresql.org/message-id/flat/17406-71e02820ae79bb40%40postgresql.org
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=7d30f59da
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Nolan | 2022-04-04 14:18:48 | Trigger functions and FDW tables |
| Previous Message | David G. Johnston | 2022-04-04 13:47:12 | Re: Transaction and SQL errors |