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 "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