Re: Aggregate function error in 7.4 - Mailing list pgsql-sql

From j knight
Subject Re: Aggregate function error in 7.4
Date
Msg-id 40180B03.3070209@myrealbox.com
Whole thread Raw
In response to Re: Aggregate function error in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Samuel Tardieu
Date:
Subject: Question about isolation
Next
From: Chester Kustarz
Date:
Subject: Re: Question about isolation