MIME-Version: 1.0
References: <CADX_1abY=D3o4Env3kzUnuMarBKt+iwAiVvfHiVZrhgMit6KkQ@mail.gmail.com>
 <CAKAnmmLM4eMORPFf=zVK=DPpGFn7+CvrDPq3LP_TjdqTTZpSxQ@mail.gmail.com>
In-Reply-To: <CAKAnmmLM4eMORPFf=zVK=DPpGFn7+CvrDPq3LP_TjdqTTZpSxQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 5 Mar 2025 10:59:44 -0500
Message-ID: <CANzqJaCCNYWN53TuCnp2fV-cR5SHDNRwibONM_6gDVP3pL8BDw@mail.gmail.com>
Subject: Re: end of COPY
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000ce612062f9a7b58"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCCNYWN53TuCnp2fV-cR5SHDNRwibONM_6gDVP3pL8BDw%40mail.gmail.com>
Precedence: bulk

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

On Wed, Mar 5, 2025 at 10:53=E2=80=AFAM Greg Sabino Mullane <htamfids@gmail=
.com>
wrote:

> On Wed, Mar 5, 2025 at 10:22=E2=80=AFAM Marc Millas <marc.millas@mokadb.c=
om>
> wrote:
>
>> Then the flow contains a single line: \. to my understanding this means
>> end of the copy
>>
>> but, Postgres generates an error : invalid input syntax for type numeric
>> "\."
>>
>
> This can happen when you send TWO backslashes and a dot, rather than a
> single backslash and a dot.
>

I hate proportional fonts. =F0=9F=98=A0

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--0000000000000ce612062f9a7b58
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Mar 5, 2025 at 10:53=E2=80=AFAM G=
reg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@gmail=
.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=
=3D"ltr">On Wed, Mar 5, 2025 at 10:22=E2=80=AFAM Marc Millas &lt;<a href=3D=
"mailto:marc.millas@mokadb.com" target=3D"_blank">marc.millas@mokadb.com</a=
>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex"><div dir=3D"ltr"><div>Then the flow contains a single l=
ine: \. to my understanding this means end of the copy=C2=A0</div><div><br>=
</div><div>but, Postgres generates an error=C2=A0: invalid input syntax for=
 type numeric &quot;\.&quot;</div></div></blockquote><div><br></div><div>Th=
is can happen=C2=A0when you send TWO backslashes and a dot, rather than a s=
ingle backslash and a dot.</div></div></div></blockquote><div></div></div><=
div><br></div><div>I hate proportional=C2=A0fonts.=C2=A0=F0=9F=98=A0</div><=
div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&g=
t;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><=
div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--0000000000000ce612062f9a7b58--