I just experienced the same problem [1] with 8.0.0beta2. [1] http://archives.postgresql.org/pgsql-bugs/2004-08/msg00086.php
-- Georgi Chorbadzhiyski http://georgi.unixsol.org/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
