Rod Taylor <pg(at)rbt(dot)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 = true and 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