Re: "trailing junk after numeric literal at or near ""512<d0>"""

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Olleg Samoylov <splarv(at)ya(dot)ru>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: "trailing junk after numeric literal at or near ""512<d0>"""
Date: 2024-12-24 15:37:49
Message-ID: 1613089.1735054669@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Olleg Samoylov <splarv(at)ya(dot)ru> writes:
> I have PostgreSQL 16.6. The log files are attached as partitions by
> file_fdw to the SQL table. Common practice. But after the error message
> "trailing junk after numeric literal at or near ""512<d0>""" (vim -b view)
> was wrote, the reading all log was stopped with error from file_fdw:

> ERROR: invalid byte sequence for encoding "UTF8": 0xd0 0x22

> The reason is the error message in the log file (which must be utf-8)
> consist of:
> \x 22 35 31 32 d0 22
> " 5 1 2 "
> and d0 is not a utf-8 character so it block reading whole log file by
> file_fdw.

You certain that server is 16.6? Because we fixed that in 16.5:

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=4fd4d7653

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-12-24 16:12:02 Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org
Previous Message Matthias Leisi 2024-12-24 14:04:25 Re: repmgr(d) versions 5.5 vs 5.4 from apt.postgresql.org