Janning Vygen <vygen@xxxxxx> writes: > the problem is quite urgent because i can't afford the time for rewriting the > app to not use temp tables. So i need to fix it. any help is very > appreciated. Show us a self-contained test case. 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