Re: ERROR: ExecEvalAggref: no aggregates in this expressioncontext

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul McGarry <paulm(at)opentec(dot)com(dot)au>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: ERROR: ExecEvalAggref: no aggregates in this expressioncontext
Date: 2000-07-06 04:44:24
Message-ID: 20348.962858664@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Paul McGarry <paulm(at)opentec(dot)com(dot)au> writes:
>> Yup. ExecEvalAggref is supposed to fetch the result of a (previously
>> computed) aggregate function. It's unhappy because it's not finding
>> anything to return. This is a bug --- can we see a complete example
>> that causes it?

> The view that I am experiencing this error on is rather nasty, so
> much so that I am going to solve the problem it was supposed to
> solve in another way.

View? Hmm, we know that views involving GROUP BY or aggregates
don't work very well. We hope to fix those problems in 7.2, but
right now there's probably not much that can be done about it.
I'd recommend avoiding views that use those features for now.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Paul McGarry 2000-07-06 05:19:51 Re: ERROR: ExecEvalAggref: no aggregates in thisexpressioncontext
Previous Message Robert B. Easter 2000-07-06 03:51:04 ALTER TABLE ADD COLUMN syntax question.