Richard Yen <[EMAIL PROTECTED]> writes: > Here's the machine where postgres is faulting: > postgreSQL version: 7.4.6
Well, the very first recommendation you're going to get is to run something newer. 7.4 is up to 7.4.12 (.13 next week) and we don't make those patch releases just to fill spare time. 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