Re: could not find pathkey item to sort - Mailing list pgsql-sql

From Tom Lane
Subject Re: could not find pathkey item to sort
Date
Msg-id 21953.1165534976@sss.pgh.pa.us
Whole thread Raw
In response to could not find pathkey item to sort  ("Phillip Smith" <phillips@weatherbeeta.com.au>)
List pgsql-sql
"Phillip Smith" <phillips@weatherbeeta.com.au> 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query is fast and function is slow
Next
From: sid tow
Date:
Subject: Problem with SQL stored procedure