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

Re: Aggregate function error in 7.4

From: j knight <enabled(at)myrealbox(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Aggregate function error in 7.4
Date: 2004-01-28 19:18:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Tom Lane wrote:
> j knight <enabled(at)myrealbox(dot)com> writes:
>>[ query with GROUP BY on a FULL JOIN USING column ]
>>psql:pgsql.dump:301: ERROR:  column "" 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.


In response to

pgsql-sql by date

Next:From: Chester KustarzDate: 2004-01-28 20:12:38
Subject: Re: Question about isolation
Previous:From: Samuel TardieuDate: 2004-01-28 17:58:53
Subject: Question about isolation

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