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: Marc Millas <marc.millas@mokadb.com>
Date: Wed, 5 Mar 2025 17:34:31 +0100
Message-ID: <CADX_1aYnt5sNG6G4vCUgY+NnzoLEN57LB5vKBtgKtg8k9qZYzw@mail.gmail.com>
Subject: Re: end of COPY
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, 
	Ron Johnson <ronljohnsonjr@gmail.com>
Content-Type: multipart/alternative; boundary="0000000000007318a5062f9af79d"
Archived-At: <https://www.postgresql.org/message-id/CADX_1aYnt5sNG6G4vCUgY%2BNnzoLEN57LB5vKBtgKtg8k9qZYzw%40mail.gmail.com>
Precedence: bulk

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

Greg... =F0=9F=91=8D

works fine now.

thanks !


Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com


On Wed, Mar 5, 2025 at 4:53=E2=80=AFPM 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.
>
> Cheers,
> Greg
>
> --
> Crunchy Data - https://www.crunchydata.com
> Enterprise Postgres Software Products & Tech Support
>
>

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

<div dir=3D"ltr"><div>Greg...=C2=A0=F0=9F=91=8D</div><div><br></div><div>wo=
rks fine now.</div><div><br></div><div>thanks !</div><div><br></div><div><b=
r></div><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"g=
mail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr">Marc MILLAS<div>Seni=
or Architect</div><div>+33607850334</div><div><a href=3D"http://www.mokadb.=
com" target=3D"_blank">www.mokadb.com</a></div><div><br></div></div></div><=
/div></div></div><br></div><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Mar 5, 2025 at 4:53=E2=
=80=AFPM Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htam=
fids@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Wed, Mar 5, 2025 at 10:2=
2=E2=80=AFAM Marc Millas &lt;<a href=3D"mailto:marc.millas@mokadb.com" targ=
et=3D"_blank">marc.millas@mokadb.com</a>&gt; wrote:</div><div class=3D"gmai=
l_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left: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 mea=
ns end of the copy=C2=A0</div><div><br></div><div>but, Postgres generates a=
n error=C2=A0: invalid input syntax for type numeric &quot;\.&quot;</div></=
div></blockquote><div><br></div><div>This can happen=C2=A0when you send TWO=
 backslashes 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_signatur=
e"><div dir=3D"ltr"><div>Greg</div><div><br></div><div>--</div><div>Crunchy=
 Data - <a href=3D"https://www.crunchydata.com" target=3D"_blank">https://w=
ww.crunchydata.com</a></div><div>Enterprise Postgres Software Products &amp=
; Tech Support</div><div><br></div></div></div></div>
</blockquote></div>

--0000000000007318a5062f9af79d--