MIME-Version: 1.0
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Mon, 23 Mar 2026 20:42:35 +0100
Message-ID: 
 <CAFj8pRCzGpsr9zTHbtTd4mGh2YPJqOEgLgt8JLiopuYA9_1xGw@mail.gmail.com>
Subject: bugfix - fix broken output in expanded aligned format, when data are
 too short
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000ccb20d064db63e45"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFj8pRCzGpsr9zTHbtTd4mGh2YPJqOEgLgt8JLiopuYA9_1xGw%40mail.gmail.com>
Precedence: bulk

--000000000000ccb20d064db63e45
Content-Type: multipart/alternative; boundary="000000000000ccb20b064db63e43"

--000000000000ccb20b064db63e43
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi

There is a bug in fe_utils

(2026-03-23 20:36:21) postgres=3D# \pset
border                   2
columns                  0
csv_fieldsep             ','
display_false            'f'
display_true             't'
expanded                 on
fieldsep                 '|'
fieldsep_zero            off
footer                   on
format                   aligned
linestyle                unicode
null                     '=E2=88=85'
numericlocale            off
pager                    1
pager_min_lines          0
recordsep                '\n'
recordsep_zero           off
tableattr
title
tuples_only              off
unicode_border_linestyle single
unicode_column_linestyle single
unicode_header_linestyle double
xheader_width            full

(2026-03-23 20:36:56) postgres=3D# select * from foo;
kuku
=E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=AC=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=90
=E2=94=82 a  =E2=94=82 b  =E2=94=82
=E2=95=9E=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=AA=E2=95=90=E2=95=90=E2=
=95=90=E2=95=90=E2=95=A1
=E2=94=82 10 =E2=94=82 20 =E2=94=82
=E2=94=82 10 =E2=94=82 20 =E2=94=82
=E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=B4=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=98
(2 rows)

(2026-03-23 20:36:58) postgres=3D# \x
Expanded display is on.
(2026-03-23 20:37:01) postgres=3D# select * from foo;
=E2=94=8C=E2=94=80[ RECORD 1 ]=E2=94=80=E2=94=90
=E2=94=82 a =E2=94=82 10 =E2=94=82
=E2=94=82 b =E2=94=82 20 =E2=94=82
=E2=95=9E=E2=95=90[ RECORD 2 ]=E2=95=90=E2=95=A1
=E2=94=82 a =E2=94=82 10 =E2=94=82
=E2=94=82 b =E2=94=82 20 =E2=94=82
=E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=B4=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=98

the bugfix is really short

pavel@nemesis:~/src/postgresql$ git diff master
diff --git a/src/fe_utils/print.c b/src/fe_utils/print.c
index 12d969e8666..58a04a902d5 100644
--- a/src/fe_utils/print.c
+++ b/src/fe_utils/print.c
@@ -1445,7 +1445,7 @@ print_aligned_vertical(const printTableContent *cont,
    /*
     * Calculate available width for data in wrapped mode
     */
-   if (cont->opt->format =3D=3D PRINT_WRAPPED)
+   if (cont->opt->format =3D=3D PRINT_WRAPPED || cont->opt->format =3D=3D
PRINT_ALIGNED)
    {
        unsigned int swidth,
                    rwidth =3D 0,

after fix:

(2026-03-23 20:40:11) postgres=3D# \x
Expanded display is on.
(2026-03-23 20:40:13) postgres=3D# select * from foo;
=E2=94=8C=E2=94=80[ RECORD 1 ]=E2=94=80=E2=94=90
=E2=94=82 a =E2=94=82 10       =E2=94=82
=E2=94=82 b =E2=94=82 20       =E2=94=82
=E2=95=9E=E2=95=90[ RECORD 2 ]=E2=95=90=E2=95=A1
=E2=94=82 a =E2=94=82 10       =E2=94=82
=E2=94=82 b =E2=94=82 20       =E2=94=82
=E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=B4=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=98

Regards

Pavel

--000000000000ccb20b064db63e43
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+PGRpdj5IaTwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+VGhlcmUgaXMg
YSBidWcgaW4gZmVfdXRpbHM8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PigyMDI2LTAzLTIzIDIw
OjM2OjIxKSBwb3N0Z3Jlcz0jIFxwc2V0IDxicj5ib3JkZXIgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgMjxicj5jb2x1bW5zIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgMDxicj5jc3ZfZmll
bGRzZXAgwqAgwqAgwqAgwqAgwqAgwqAgJiMzOTssJiMzOTs8YnI+ZGlzcGxheV9mYWxzZSDCoCDC
oCDCoCDCoCDCoCDCoCYjMzk7ZiYjMzk7PGJyPmRpc3BsYXlfdHJ1ZSDCoCDCoCDCoCDCoCDCoCDC
oCAmIzM5O3QmIzM5Ozxicj5leHBhbmRlZCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCBvbjxicj5m
aWVsZHNlcCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmIzM5O3wmIzM5Ozxicj5maWVsZHNlcF96
ZXJvIMKgIMKgIMKgIMKgIMKgIMKgb2ZmPGJyPmZvb3RlciDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCBvbjxicj5mb3JtYXQgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgYWxpZ25lZDxicj5s
aW5lc3R5bGUgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqB1bmljb2RlPGJyPm51bGwgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgJiMzOTviiIUmIzM5Ozxicj5udW1lcmljbG9jYWxlIMKgIMKg
IMKgIMKgIMKgIMKgb2ZmPGJyPnBhZ2VyIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgMTxi
cj5wYWdlcl9taW5fbGluZXMgwqAgwqAgwqAgwqAgwqAwPGJyPnJlY29yZHNlcCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCYjMzk7XG4mIzM5Ozxicj5yZWNvcmRzZXBfemVybyDCoCDCoCDCoCDCoCDC
oCBvZmY8YnI+dGFibGVhdHRyIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPGJyPnRpdGxlIMKgIMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPGJyPnR1cGxlc19vbmx5IMKgIMKgIMKgIMKgIMKgIMKg
IMKgb2ZmPGJyPnVuaWNvZGVfYm9yZGVyX2xpbmVzdHlsZSBzaW5nbGU8YnI+dW5pY29kZV9jb2x1
bW5fbGluZXN0eWxlIHNpbmdsZTxicj51bmljb2RlX2hlYWRlcl9saW5lc3R5bGUgZG91YmxlPGJy
PnhoZWFkZXJfd2lkdGggwqAgwqAgwqAgwqAgwqAgwqBmdWxsPGJyPjxicj48L2Rpdj48ZGl2Pjxz
cGFuIHN0eWxlPSJmb250LWZhbWlseTptb25vc3BhY2UiPigyMDI2LTAzLTIzIDIwOjM2OjU2KSBw
b3N0Z3Jlcz0jIHNlbGVjdCAqIGZyb20gZm9vOzxicj5rdWt1PGJyPuKUjOKUgOKUgOKUgOKUgOKU
rOKUgOKUgOKUgOKUgOKUkDxicj7ilIIgYSDCoOKUgiBiIMKg4pSCPGJyPuKVnuKVkOKVkOKVkOKV
kOKVquKVkOKVkOKVkOKVkOKVoTxicj7ilIIgMTAg4pSCIDIwIOKUgjxicj7ilIIgMTAg4pSCIDIw
IOKUgjxicj7ilJTilIDilIDilIDilIDilLTilIDilIDilIDilIDilJg8YnI+KDIgcm93cyk8YnI+
PGJyPigyMDI2LTAzLTIzIDIwOjM2OjU4KSBwb3N0Z3Jlcz0jIFx4PGJyPkV4cGFuZGVkIGRpc3Bs
YXkgaXMgb24uPGJyPigyMDI2LTAzLTIzIDIwOjM3OjAxKSBwb3N0Z3Jlcz0jIHNlbGVjdCAqIGZy
b20gZm9vOzxicj7ilIzilIBbIFJFQ09SRCAxIF3ilIDilJA8YnI+4pSCIGEg4pSCIDEwIOKUgjxi
cj7ilIIgYiDilIIgMjAg4pSCPGJyPuKVnuKVkFsgUkVDT1JEIDIgXeKVkOKVoTxicj7ilIIgYSDi
lIIgMTAg4pSCPGJyPuKUgiBiIOKUgiAyMCDilII8YnI+4pSU4pSA4pSA4pSA4pS04pSA4pSA4pSA
4pSA4pSYPC9zcGFuPjxicj48YnI+PC9kaXY+PGRpdj50aGUgYnVnZml4IGlzIHJlYWxseSBzaG9y
dDwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+cGF2ZWxAbmVtZXNpczp+L3NyYy9wb3N0Z3Jlc3Fs
JCBnaXQgZGlmZiBtYXN0ZXI8YnI+ZGlmZiAtLWdpdCBhL3NyYy9mZV91dGlscy9wcmludC5jIGIv
c3JjL2ZlX3V0aWxzL3ByaW50LmM8YnI+aW5kZXggMTJkOTY5ZTg2NjYuLjU4YTA0YTkwMmQ1IDEw
MDY0NDxicj4tLS0gYS9zcmMvZmVfdXRpbHMvcHJpbnQuYzxicj4rKysgYi9zcmMvZmVfdXRpbHMv
cHJpbnQuYzxicj5AQCAtMTQ0NSw3ICsxNDQ1LDcgQEAgcHJpbnRfYWxpZ25lZF92ZXJ0aWNhbChj
b25zdCBwcmludFRhYmxlQ29udGVudCAqY29udCw8YnI+wqAgwqAgLyo8YnI+wqAgwqAgwqAqIENh
bGN1bGF0ZSBhdmFpbGFibGUgd2lkdGggZm9yIGRhdGEgaW4gd3JhcHBlZCBtb2RlPGJyPsKgIMKg
IMKgKi88YnI+LSDCoCBpZiAoY29udC0mZ3Q7b3B0LSZndDtmb3JtYXQgPT0gUFJJTlRfV1JBUFBF
RCk8YnI+KyDCoCBpZiAoY29udC0mZ3Q7b3B0LSZndDtmb3JtYXQgPT0gUFJJTlRfV1JBUFBFRCB8
fCBjb250LSZndDtvcHQtJmd0O2Zvcm1hdCA9PSBQUklOVF9BTElHTkVEKTxicj7CoCDCoCB7PGJy
PsKgIMKgIMKgIMKgIHVuc2lnbmVkIGludCBzd2lkdGgsPGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIHJ3aWR0aCA9IDAsPGJyPjxicj48L2Rpdj48ZGl2PmFmdGVyIGZpeDo8L2Rpdj48
ZGl2Pjxicj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTptb25vc3BhY2UiPigy
MDI2LTAzLTIzIDIwOjQwOjExKSBwb3N0Z3Jlcz0jIFx4PGJyPkV4cGFuZGVkIGRpc3BsYXkgaXMg
b24uPGJyPigyMDI2LTAzLTIzIDIwOjQwOjEzKSBwb3N0Z3Jlcz0jIHNlbGVjdCAqIGZyb20gZm9v
Ozxicj7ilIzilIBbIFJFQ09SRCAxIF3ilIDilJA8YnI+4pSCIGEg4pSCIDEwIMKgIMKgIMKgIOKU
gjxicj7ilIIgYiDilIIgMjAgwqAgwqAgwqAg4pSCPGJyPuKVnuKVkFsgUkVDT1JEIDIgXeKVkOKV
oTxicj7ilIIgYSDilIIgMTAgwqAgwqAgwqAg4pSCPGJyPuKUgiBiIOKUgiAyMCDCoCDCoCDCoCDi
lII8YnI+4pSU4pSA4pSA4pSA4pS04pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSYPGJy
Pjwvc3Bhbj48YnI+PC9kaXY+PGRpdj5SZWdhcmRzPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5Q
YXZlbDwvZGl2PjxkaXY+PGJyPjwvZGl2PjwvZGl2Pg0K
--000000000000ccb20b064db63e43--

--000000000000ccb20d064db63e45
Content-Type: text/x-patch; charset="US-ASCII";
 name="0001-fix-expended-aligned-format.patch"
Content-Disposition: attachment;
	filename="0001-fix-expended-aligned-format.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mn3lb2v60>
X-Attachment-Id: f_mn3lb2v60

RnJvbSAxMzEyNjE2MjBmMzU5OTdiZTFjZjJiNDcyNjU3N2MyYzI4NDMzNWQyIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiAib2tib2JAZ2l0aHViLmNvbSIgPHBhdmVsLnN0ZWh1bGVAZ21h
aWwuY29tPgpEYXRlOiBNb24sIDIzIE1hciAyMDI2IDIwOjM5OjMxICswMTAwClN1YmplY3Q6IFtQ
QVRDSF0gZml4IGV4cGVuZGVkIGFsaWduZWQgZm9ybWF0CgotLS0KIHNyYy9mZV91dGlscy9wcmlu
dC5jIHwgMiArLQogMSBmaWxlIGNoYW5nZWQsIDEgaW5zZXJ0aW9uKCspLCAxIGRlbGV0aW9uKC0p
CgpkaWZmIC0tZ2l0IGEvc3JjL2ZlX3V0aWxzL3ByaW50LmMgYi9zcmMvZmVfdXRpbHMvcHJpbnQu
YwppbmRleCAxMmQ5NjllODY2Ni4uNThhMDRhOTAyZDUgMTAwNjQ0Ci0tLSBhL3NyYy9mZV91dGls
cy9wcmludC5jCisrKyBiL3NyYy9mZV91dGlscy9wcmludC5jCkBAIC0xNDQ1LDcgKzE0NDUsNyBA
QCBwcmludF9hbGlnbmVkX3ZlcnRpY2FsKGNvbnN0IHByaW50VGFibGVDb250ZW50ICpjb250LAog
CS8qCiAJICogQ2FsY3VsYXRlIGF2YWlsYWJsZSB3aWR0aCBmb3IgZGF0YSBpbiB3cmFwcGVkIG1v
ZGUKIAkgKi8KLQlpZiAoY29udC0+b3B0LT5mb3JtYXQgPT0gUFJJTlRfV1JBUFBFRCkKKwlpZiAo
Y29udC0+b3B0LT5mb3JtYXQgPT0gUFJJTlRfV1JBUFBFRCB8fCBjb250LT5vcHQtPmZvcm1hdCA9
PSBQUklOVF9BTElHTkVEKQogCXsKIAkJdW5zaWduZWQgaW50IHN3aWR0aCwKIAkJCQkJcndpZHRo
ID0gMCwKLS0gCjIuNTMuMAoK
--000000000000ccb20d064db63e45--