Re: Server Crash wit insert ... select ... group by

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