pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Error: could not find pathkey item to sort
2+ messages / 2 participants
[nested] [flat]
* Error: could not find pathkey item to sort
@ 2008-04-22 01:09 Theerasak Maneeneim <theerasak@thns.co.th>
2008-04-21 14:23 ` Re: Error: could not find pathkey item to sort Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Theerasak Maneeneim @ 2008-04-22 01:09 UTC (permalink / raw)
To: pgsql-sql
Hi Everyone,
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
WHERE
cscd = '2203'
AND cs_partno = '35732SSA'
AND delipnt_no = '001'
AND plantcd_no = '003'
AND locatto = trim(both FROM 'SS')
AND fcstrec_dt < '20080910'
AND latest_flg = 'N';
I have not ever seen the error in version 8.1 and 8.2. Now, I
have already revised my program by removed the word "DISTINCT" but I
want to know what is cause of this error. Could you please to explain to me?
Thank you very much.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Error: could not find pathkey item to sort
2008-04-22 01:09 Error: could not find pathkey item to sort Theerasak Maneeneim <theerasak@thns.co.th>
@ 2008-04-21 14:23 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2008-04-21 14:23 UTC (permalink / raw)
To: theerasak@thns.co.th; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-04-22 01:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-22 01:09 Error: could not find pathkey item to sort Theerasak Maneeneim <theerasak@thns.co.th>
2008-04-21 14:23 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox