Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpI86-00054h-E4 for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 19:36:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gpI85-0007uJ-0C for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 19:36:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpI84-0007uC-KV for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 19:36:04 +0000 Received: from sonic315-14.consmr.mail.bf2.yahoo.com ([74.6.134.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpI7x-0007LF-J2 for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 19:36:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548963355; bh=BIg+pqYJcRfAWZAzNKCtCTlOfhom5wzBBX16xkhQNWY=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=o1LRPbS6lVHihkjXm1lwNw5OfSRnDc/otXJUVgYUIAKw8urG2pZw0i/nmwitmDcuPGMFZ/hDqtgT/BrgLVMizEGXAzvEn7U86MbNR31GwA9RSMSdqqDACdizFaGHEEp6dHqeeojs12q9HaIBZ36wTMD+SzAgcWDQYL1hyVG6RmnB5im5CfrEJQi4P4p0V9reMz+BCZD9d7GRzrjOe6QLgCN4hDT+JBiCu06CkZ+UZPWNNMAlAhKV65768sStHJ1MFzu4vYk6JHXFjqeGuNO9+QFHuG4UMvw3YEw4wiSGckXvIFXuYNAvn+8SHsl59He+0fBodYgSDfpec4I/MXsYGw== X-YMail-OSG: gNRpisMVM1kTxOxlr5DoOXk30GtGv87KqdnxGgBmRIrIGhtlRez6UjzeeFtCgnw lY4J.QUGU1egl1HnKkRAqU2uVZeNguv8Mlm1JwG18Nvj99rkpqDmfT9ISTI2BAK_yYpP7BJt8i_m U6Z8FIMg3yOXzVZcc1.bkf3FMZVMxDnBrGkL.XhgNFXfYw5gF5EWqEItsbQQPFDaI66mKtC66y4F DcdxntSjxhTjfhcqOtXO.ghAgQJPcJdVbdspnn4Mp9_8avsE0OYJmRkDXf9fJqDdZ0WKFf1dlYgF 69BzeEJwSqRnb_mXTbXUkFa2hkv3T7NE66GrUw_3cjRwP13GqVIGyZZAKDSYS0Uan09Rkkac8FEp FHfcr7EC0ToXqYetOLptOC198RSSqtVDqL_w6WFsPlytoR42EDGPfP_ERNR.wpHCA3FEHOocEYst .F_Hcgn70Tt39zzVYeNtv1eDbIhQuE.ReR65r_6clhE9Mla_HMfZzZoKWM_sW0RZOZMG0WNpF_cC 404P22UB2CTCySW5IdV_p6IlxET0opko0agrsu3APVMmytd.Z4cUJgO4L78EEwNv730fkqgJn7em Ah2f2AiTjaGB5zraPZ5HhjIGK73AyiCE2wB43Xxh9vJiXQPbMxtcP0x7Revuc0Gitn22mnGOGCMg z.X58zcB.0pYbiuTm2ZAaZFh5xXQK6sEd59mtAuzlNyx1o8G2POx30UGfEhmXMjqz4RRzf39ftQv I3nmFuyoDxIH___IsInil4rNOmkxtVkZ9PXQ0ZV40E6W7Z12cfsDRCmeTupq7I9o9YJ6MXB7wFKr Uex3OVMc0hT5QqEqTOMOB5A3AluyCu2WfNF.oM2BRtTV4SK8j0fxmQeDQjYOSl5bu0bZ5V0ni22U afMmqQ_BkPP64Z8BRyJUoSyDlzhz6otujwT.OcFcGtq9TIX.y5rqbJxR28IlJ5dcNs20QoJKjrXG 1juObEYgWYEbO_s0p6f26uVUU1BJflXGCIe6Yr7qrOYhWXyZsUqYeIs5cD1LfyQgeL6kFyrWrt4G QnxWbWh82OCuh.Kh.IEavrXBDgfcj2CoSGvDZcPJ2gtND6foXfpMdfbB7gkkwfWFhMSIoVyI- Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.bf2.yahoo.com with HTTP; Thu, 31 Jan 2019 19:35:55 +0000 Date: Thu, 31 Jan 2019 19:35:44 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Scott Ribe Cc: Pgsql-admin Message-ID: <2031259937.990023.1548963344432@mail.yahoo.com> In-Reply-To: <49E280F0-7021-4FD7-AA99-985A86FA899C@elevated-dev.com> References: <1861353148.992207.1548962087385.ref@mail.yahoo.com> <1861353148.992207.1548962087385@mail.yahoo.com> <49E280F0-7021-4FD7-AA99-985A86FA899C@elevated-dev.com> Subject: Re: insert aborted commands ignored MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_990022_698787886.1548963344431" X-Mailer: WebService/1.1.13027 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 5730 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_990022_698787886.1548963344431 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable that is the first error.=C2=A0 I get the same one over and over with=C2=A0E= RROR:current transaction is aborted, commands ignored until end of transact= ion block from the first one until the last one for each insert. thank you,=C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Thursday, January 31, 2019 2:28 PM, Scott Ribe wrote: =20 =20 > On Jan 31, 2019, at 12:14 PM, Pepe TD Vo wrote: >=20 > ERROR:current transaction is aborted, commands ignored until end of trans= action block >=20 > I see each column has extra E' in front, is that right in postgres?=C2=A0= How can I prevent this issue? The e should not be a problem, it's for "extended" strings, which allow som= e things that the SQL standard doesn't. But 'E'l130' is not legit; was that= a copy/paste error. And you need to post the FIRST error in the logs, not the last one. =20 ------=_Part_990022_698787886.1548963344431 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
that is the first error.  I get the same one over= and over with 
ERRO= R:current transaction is aborted, commands ignored until end of transaction= block from the first one until the last one for each insert.
<= div dir=3D"ltr">
thank you,
&nbs= p;
Bach-Nga

No one in this world is pure and perfect.  If you av= oid people for their mistakes you will be alone. So judge less, love and fo= rgive more.
To call him a dog hardl= y seems to do him justice though in as much as he had four legs, a tail, an= d barked, I admit he was, to all outward appearances. But to those who knew= him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care = deeply **Speak kindly.
*** Genuinely rich *** Faithful talen= t *** Sharing success


<= div style=3D"font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, = Lucida Grande, sans-serif; font-size: 16px;">
On Thursday, January 31, 2019 2:28 PM, Scott Ribe &l= t;scott_ribe@elevated-dev.com> wrote:



> On Jan 31, 2019, at 12:14 PM, Pepe TD = Vo <pepevo@yahoo.com> wrote:
> <= br clear=3D"none">> ERROR:current transaction is aborted, commands ignor= ed until end of transaction block
>
> I see each column has extra E' in front, is that right in postgres?&n= bsp; How can I prevent this issue?


The e should not be a problem, it's for "extended" strings, which allow = some things that the SQL standard doesn't. But 'E'l130' is not legit; was t= hat a copy/paste error.

And you need t= o post the FIRST error in the logs, not the last one.


=
------=_Part_990022_698787886.1548963344431--