Re: Server Crash wit insert ... select ... group by - Mailing list pgsql-bugs

Ramin Motakef <ramin@motakef.de> writes:
> The Following query causes the backend to crash:

> INSERT INTO bmonth (year,month,hours)
> SELECT date_part('year',day),
>        date_part('month',day),
>        to_hour(sum(stop-start))
> FROM stunden
> GROUP BY date_part('year',day), date_part('month',day);

This is fixed in 7.1.

            regards, tom lane