Re: regtype sorting broken in 8.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: regtype sorting broken in 8.3
Date: 2007-11-06 16:59:34
Message-ID: 22939.1194368374@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> pei=# select castsource::regtype, casttarget::regtype, castcontext from pg_cast order by 1,2;
> ERROR: XX000: could not find pathkey item to sort
> LOCATION: make_sort_from_pathkeys, createplan.c:2812

Hmph. When we hacked that function last week, I was kinda wondering if
it shouldn't strip RelabelType from *both* sides of the comparison.
Looks like it does need that after all.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2007-11-06 17:16:09 Re: Weird type selection choice
Previous Message Alvaro Herrera 2007-11-06 16:58:05 Re: Fix pg_dump dependency on postgres.h