MIME-Version: 1.0
References: <CADX_1abY=D3o4Env3kzUnuMarBKt+iwAiVvfHiVZrhgMit6KkQ@mail.gmail.com>
In-Reply-To: <CADX_1abY=D3o4Env3kzUnuMarBKt+iwAiVvfHiVZrhgMit6KkQ@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 5 Mar 2025 10:52:24 -0500
Message-ID: <CAKAnmmLM4eMORPFf=zVK=DPpGFn7+CvrDPq3LP_TjdqTTZpSxQ@mail.gmail.com>
Subject: Re: end of COPY
To: Marc Millas <marc.millas@mokadb.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, 
	Ron Johnson <ronljohnsonjr@gmail.com>
Content-Type: multipart/alternative; boundary="0000000000005bfba0062f9a6265"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLM4eMORPFf%3DzVK%3DDPpGFn7%2BCvrDPq3LP_TjdqTTZpSxQ%40mail.gmail.com>
Precedence: bulk

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

On Wed, Mar 5, 2025 at 10:22=E2=80=AFAM Marc Millas <marc.millas@mokadb.com=
> 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.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--0000000000005bfba0062f9a6265
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:22=E2=80=AFAM M=
arc Millas &lt;<a href=3D"mailto:marc.millas@mokadb.com">marc.millas@mokadb=
.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>Then=
 the flow contains a single line: \. 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></bloc=
kquote><div><br></div><div>This can happen=C2=A0when you send TWO backslash=
es and a dot, rather than a single backslash and a dot.</div><div><br></div=
><div>Cheers,</div></div><div dir=3D"ltr" class=3D"gmail_signature"><div di=
r=3D"ltr"><div>Greg</div><div><br></div><div>--</div><div>Crunchy Data - <a=
 href=3D"https://www.crunchydata.com" target=3D"_blank">https://www.crunchy=
data.com</a></div><div>Enterprise Postgres Software Products &amp; Tech Sup=
port</div><div><br></div></div></div></div>

--0000000000005bfba0062f9a6265--