Tom Lane wrote:
Gerhard Hintermayer <g.hintermayer@xxxxxxxx> 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