Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3
Date
Msg-id 1124027.1639683852@sss.pgh.pa.us
Whole thread Raw
In response to Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3  (John Naylor <john.naylor@enterprisedb.com>)
List pgsql-bugs
John Naylor <john.naylor@enterprisedb.com> writes:
> A customer reported a planning regression from 11.5 to 12.9. After
> bisecting, it seems the fix for the thread subject here, commit
> f230614da28, broke partition pruning in some cases.

[ facepalm... ]  I didn't consider the possibility that
find_typmod_coercion_function would find something ...
so we're getting an actual call of bpchar(), not just
a RelabelType.

            regards, tom lane



pgsql-bugs by date:

Previous
From: John Naylor
Date:
Subject: Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3
Next
From: "James Pang (chaolpan)"
Date:
Subject: RE: BUG #17326: Postgres crashed when pg_reload_conf() with ssl certificate parameters