Re: regtype sorting broken in 8.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: regtype sorting broken in 8.3
Date
Msg-id 22939.1194368374@sss.pgh.pa.us
Whole thread Raw
In response to regtype sorting broken in 8.3  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Opinion / advice needed for TODO: function params ref by name
Next
From: Peter Eisentraut
Date:
Subject: Re: Weird type selection choice