From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Naylor <john.naylor@enterprisedb.com>
cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: CAST from numeric(18,3) to numeric doesnt work, posgresql 13.3
In-reply-to: 
 <CAFBsxsEfbFHEkouc+FSj+3K1sHipLPbEC67L0SAe-9-da8QtYg@mail.gmail.com>
References: 
 <CABNQVagu3bZGqiTjb31a8D5Od3fUMs7Oh3gmZMQZVHZ=uWWWfQ@mail.gmail.com>
 <2352034.1628127322@sss.pgh.pa.us>
 <CAEZATCWcOOGcYwTV0pv2F0o07w+dL7A2JN88fq5U-K29i=Ls=A@mail.gmail.com>
 <2395471.1628180285@sss.pgh.pa.us>
 <CAKFQuwbcqiOK_XbjkgRK9dTH9n-GmpJtgWUp=Jh+7kEOOVnoGQ@mail.gmail.com>
 <2501011.1628277029@sss.pgh.pa.us>
 <CAFBsxsEfbFHEkouc+FSj+3K1sHipLPbEC67L0SAe-9-da8QtYg@mail.gmail.com>
Comments: In-reply-to John Naylor <john.naylor@enterprisedb.com>
	message dated "Thu, 16 Dec 2021 14:38:29 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1124026.1639683852.1@sss.pgh.pa.us>
Date: Thu, 16 Dec 2021 14:44:12 -0500
Message-ID: <1124027.1639683852@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1124027.1639683852%40sss.pgh.pa.us>
Precedence: bulk

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