Does pgfsck work on 7.4.x?
>
> Otherwise, maybe something here will help:
> http://svana.org/kleptog/pgsql/pgfsck.html
>
> ---------------------------(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