Rod Taylor <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
