Re: [SQL] Postres falls down on "having" - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Postres falls down on "having"
Date
Msg-id 5141.934296932@sss.pgh.pa.us
Whole thread Raw
In response to Postres falls down on "having"  (Paul Mamin <pm@sky.ru>)
List pgsql-sql
Paul Mamin <pm@sky.ru> writes:
> And when result is not empty - everything's Ok.
> But when it's empty then [ backend crashes ]

I can reproduce this bug with the current development sources.
Will look into it.  A quick look at a backtrace suggests that
the problem is triggered by the "sum(int8(inb))>=maxinb" part
of the HAVING clause.  You might be able to work around it if
you can use int4 or float instead of int8 ...
        regards, tom lane


pgsql-sql by date:

Previous
From: "Giovanni B. Stefanoni"
Date:
Subject: rpm 6.5 requires libcurses.so.4?
Next
From: David Ouellet
Date:
Subject: Re: [SQL] Question about arrays