Re: [BUGS] Server Crash wit insert ... select ... group by

[Tom Lane]

Ramin Motakef <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]