regtype sorting broken in 8.3
Started by Peter Eisentrautabout 18 years ago2 messages
This used to work in 8.2:
pei=# select castsource::regtype, casttarget::regtype, castcontext from pg_cast order by 1,2;
But int 8.3 it says:
ERROR: XX000: could not find pathkey item to sort
LOCATION: make_sort_from_pathkeys, createplan.c:2812
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Re: regtype sorting broken in 8.3
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