On Wed, Oct 29, 2014 at 3:00 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> federico(at)brandwatch(dot)com writes:
>> We noticed a server crash with SEGFAULT after the upgrade to 9.2.9 with the
>> queries involving a large number of sub partitions.
>
> Hm. The given test case works fine for me in 9.2 branch tip. I wonder
> whether commit 71b88cf52e3baccf6be77709fece5837ef04ea20 fixed it.
Some bisecting later... Yes that's fixed with 71b88cf. This fix will
show up in the next minor releases 9.2.10, 9.3.6 etc. You came up with
a test case more simple than the bug report at the origin of 71b88cf,
still involving grand-child relations though.
--
Michael