public inbox for [email protected]  

help / color / mirror / Atom feed

From: Olleg Samoylov <[email protected]>
To: [email protected]
Subject: "trailing junk after numeric literal at or near ""512<d0>"""
Date: Tue, 24 Dec 2024 08:46:09 +0300
Message-ID: <[email protected]> (raw)

Hi all.

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. I think the correct behavior must be the error log function 
must mask the wrong bytes by the ESC sequences, so PostgreSQL will be 
able read such log file with help of file_fdw.
-- 
Olleg

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: "trailing junk after numeric literal at or near ""512<d0>"""
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox