Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ramin Motakef <ramin(at)motakef(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Server Crash wit insert ... select ... group by
Date: 2001-03-19 00:03:48
Message-ID: 27724.984960228@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Ramin Motakef <ramin(at)motakef(dot)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

In response to

pgsql-bugs by date

Next:From: Julian RichardsonDate: 2001-03-19 09:31:37
Subject: 7.03 JDBC drivers & large objects
Previous:From: Ramin MotakefDate: 2001-03-18 12:46:05
Subject: Server Crash wit insert ... select ... group by

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group