X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 21428D1B492
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 28 Jan 2004 19:38:47 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 61238-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 28 Jan 2004 15:38:17 -0400 (AST)
Received: from pd2mo1so.prod.shaw.ca (shawidc-mo1.cg.shawcable.net
	[24.71.223.10])
	by svr1.postgresql.org (Postfix) with ESMTP id 1E159D1C515
	for <pgsql-sql@postgresql.org>; Wed, 28 Jan 2004 15:38:16 -0400 (AST)
Received: from pd4mr4so.prod.shaw.ca
	(pd4mr4so-qfe3.prod.shaw.ca [10.0.141.215]) by l-daemon
	(iPlanet Messaging Server 5.2 HotFix 1.18 (built Jul 28 2003))
	with ESMTP id <0HS700AFISAEJC@l-daemon> for pgsql-sql@postgresql.org;
	Wed, 28 Jan 2004 12:18:14 -0700 (MST)
Received: from pn2ml6so.prod.shaw.ca
	(pn2ml6so-qfe0.prod.shaw.ca [10.0.121.150]) by l-daemon
	(iPlanet Messaging Server 5.2 HotFix 1.18 (built Jul 28 2003))
	with ESMTP id <0HS700GY0SAE0G@l-daemon> for pgsql-sql@postgresql.org;
	Wed, 28 Jan 2004 12:18:14 -0700 (MST)
Received: from myrealbox.com
	(h68-146-184-143.cg.shawcable.net [68.146.184.143]) by l-daemon
	(iPlanet Messaging Server 5.2 HotFix 1.18 (built Jul 28 2003))
	with ESMTP id <0HS70073NSAET7@l-daemon> for pgsql-sql@postgresql.org;
	Wed, 28 Jan 2004 12:18:14 -0700 (MST)
Date: Wed, 28 Jan 2004 12:18:27 -0700
From: j knight <enabled@myrealbox.com>
Subject: Re: Aggregate function error in 7.4
In-reply-to: <10762.1075276201@sss.pgh.pa.us>
To: pgsql-sql@postgresql.org
Message-id: <40180B03.3070209@myrealbox.com>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii; format=flowed
Content-transfer-encoding: 7BIT
X-Accept-Language: en-us, en
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6)
	Gecko/20040113
References: <40175887.2080108@myrealbox.com> <10762.1075276201@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/239
X-Sequence-Number: 16632

Tom Lane wrote:
> j knight <enabled@myrealbox.com> writes:
> 
>>[ query with GROUP BY on a FULL JOIN USING column ]
>>psql:pgsql.dump:301: ERROR:  column "r.day" must appear in the GROUP BY 
>>clause or be used in an aggregate function
> 
> 
> Argh.  This is the result of a thinko in an optimization added in 7.4.
> The patch is attached...

Thank you Tom. This does indeed solve the problem.



.joel