Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Error: could not find pathkey item to sort
Date
Msg-id 10796.1208787786@sss.pgh.pa.us
Whole thread Raw
In response to Error: could not find pathkey item to sort  (Theerasak Maneeneim <theerasak@thns.co.th>)
List pgsql-sql
Tree view 
Theerasak Maneeneim <theerasak@thns.co.th> writes:
>            I had some problem with postgresql 8.3.1. I had got an error 
> message, ERROR:  could not find pathkey item to sort, when
> I use this query statement:

>            SELECT   INTO   wk_fcstrec_dt   DISTINCT  MAX(fcstrec_dt) 
> FROM a_cusfcst                   

This is already reported and fixed, thanks.

http://archives.postgresql.org/pgsql-bugs/2008-03/msg00275.php
        regards, tom lane

pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Having a mental block with (self) outer joins
Next
From: "Jan Peters"
Date:
Subject: Problems with function while migrating from Windows to Linux