Re: Hashagg planning bug (8.0.1)

Rod Taylor <pg@rbt.ca> writes:
> It would seem that the planner does not take into account whether the
> datatypes involved have the capability to use hash aggregates or not.

> sdb=# explain select query_start, current_query    from pg_locks join stat_activity on pid = procpid where granted =
trueand transaction in (select transaction from pg_locks where granted = false);
 
> ERROR:  could not find hash function for hash operator 716373

What's stat_activity?  I thought you meant pg_stat_activity, but that
works fine here.
        regards, tom lane