Re: segfault on query

alex <alex.pgsql@kerkhove.net> writes:
> I'd like to report a bug. I'm running pgsql-9.3.5 on debian wheezy
> (amd64, up2date). Latest pgsql binary from pgdg wheezy repo.

The given script doesn't crash for me on 9.3 branch tip; that and the
fact that you don't see it on 9.4.0 suggests strongly that it's already
been fixed post-9.3.5.  Given the query structure I'd bet that you need
this patch:

http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=b2b95de61e2e1c4647fa902c3b946109c55451c4

We're overdue for back-branch bugfix releases, but with the holiday
season now in full swing, nothing's likely to happen till mid-January
at the earliest.  Perhaps you can apply the patch and build your own
version meanwhile.

            regards, tom lane