Re: Error: could not find pathkey item to sort

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: theerasak(at)thns(dot)co(dot)th
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Error: could not find pathkey item to sort
Date: 2008-04-21 14:23:06
Message-ID: 10796.1208787786@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Theerasak Maneeneim <theerasak(at)thns(dot)co(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Theerasak Maneeneim 2008-04-22 01:09:09 Error: could not find pathkey item to sort
Previous Message Thomas Kellerer 2008-04-21 14:15:20 Re: Having a mental block with (self) outer joins