"Phillip Smith" <[EMAIL PROTECTED]> writes: > Since upgrading to PG 8.2, I'm getting this error on a nightly (bash) > script > ERROR: could not find pathkey item to sort
I think this is a variant manifestation of the same bug already reported here: http://archives.postgresql.org/pgsql-hackers/2006-12/msg00284.php and fixed here: http://archives.postgresql.org/pgsql-committers/2006-12/msg00056.php Leastwise, it went away for me after applying that patch ... 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
