"alex tsai" <alex_tsai (AT) pisem (DOT) net> writes:
You haven't really provided enough info to let anyone help you, but
sometimes this sort of error is a symptom of corrupt data. If you try
to pg_dump the table, does it work?

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