Date: Sat, 30 Nov 2019 15:21:25 +0100
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: paul@intekon.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16143: PGTYPEStimestamp_fmt_asc() returns the incorrect
 month when the format specifier %b is used.
Message-ID: <20191130142125.5bwzvzwadkrtuffl@development>
References: <16143-0d861eb8688d3fef@postgresql.org>
 <20191129203832.xybuswyoa455mwy2@development>
 <8272.1575060224@sss.pgh.pa.us>
 <20191129213614.o2567i47yfsrqx62@development>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Disposition: inline
In-Reply-To: <20191129213614.o2567i47yfsrqx62@development>
Precedence: bulk

On Fri, Nov 29, 2019 at 10:36:14PM +0100, Tomas Vondra wrote:
>On Fri, Nov 29, 2019 at 03:43:44PM -0500, Tom Lane wrote:
>>Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
>>>The attached patch should fix this, I believe - both for %b and %B.
>>
>>Yeah, I'd just come to the same conclusion.  You're welcome to
>>do the commits, of course.
>>
>
>OK, I'll commit shortly.
>

OK, pushed with backpatch to all supported branches. Turns out this is a
pretty ancient bug - it's there since at least 2003, I stopped digging
after that.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services