Re: pg_controldata/pg_resetxlog "Latest checkpoint's NextXID" format

On 12/29/2015 01:18 PM, Heikki Linnakangas wrote:
> On 29/12/15 07:14, Joe Conway wrote:
>> I wonder why "Latest checkpoint's NextXID" is formated like this:
>>
>> 8<-------------------------
>> printf(_("Latest checkpoint's NextXID: %u/%u\n"),
>> ControlFile.checkPointCopy.nextXidEpoch,
>> ControlFile.checkPointCopy.nextXid);
>> 8<-------------------------
>>
>> Shouldn't it use "%X/%X", same as e.g. "Prior checkpoint location" and
>> all the other XIDs?
>
> No. The "locations" in the output are WAL locations. Those are
> customarily printed with %X/%X. But NextXID is a transaction ID, those
> are printed in decimal, with %u.

But Joe has a point here.... Others could also be confused if he doubted
about this.

"Latest checkpoint's NextXID: %u:%u\n", maybe ??
(slash becomes colon)

Worst part: fuzzies the translations unnecesarily

/ J.L.