Re: ERROR: unexpected hash relation size:

Tom Lane wrote:
> Gerhard Hintermayer <g.hintermayer@inode.at> writes:
>> ... x should be y
>> I do get these messages one 2 of my servers running mostly on identical
>> data. The servers are unix-based and are running 8.1.8 under linux (Gentoo).
>
> Update.
>
> http://developer.postgresql.org/pgdocs/postgres/release-8-1-9.html
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>
Thanks, will do that ASAP.
But strange, that this problem is encoutered after 2 month running 8.1.8
flawless (without any changes to indices and database scheme)

Regards
Gerhard