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 1gpIEW-0005NK-GI for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 19:42:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gpIEV-00087w-0M for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 19:42:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpIEU-00087l-Oi for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 19:42:42 +0000 Received: from sonic315-14.consmr.mail.bf2.yahoo.com ([74.6.134.124]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpIER-00080n-Qb for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 19:42:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548963756; bh=6IJSPoZZ6KKBgJGLOho5B5hDJFc0OZH+01fA4M5kIiY=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=s8HjGSQD9NRa6jyaSxBCPR0k76VijYnTfUn4nvhofvIE4aVh0RWVeRpl9T3ir0L5GXuzefVk1r5OEi8+hSr4WGFgKegbhpqMse/+S4K7s+PR1bRlFqhvk4CchEWJ20mcSXbQs4qqk7nvI4mOzK6YDJQS6OnquHvm1h4IzoMuF8ACrBpRT809sb500kFkr7Kn7nWjQQ/W9vm5EEFOl5WMjEdxEZwOqW/Tqvd6nAcSiXN8aOwoADNHuXve90xA3Xuzrc94xb2ALFYvmEaHe/ofMIJz4xc+oNAFFRFSFSUGQBNBji+u/iGcWLas4m87L/NILC1hpm4VfjMPWxqKVeMFQA== X-YMail-OSG: ZUgcfwoVM1knu6tpW48dvNnpLeNbEoBgrP2K4gva5aFeO0MjtZf8Zqz0Rnge_ZD cZRFrdGlhJdwwD67JFmDK7ZlFhgu8kC3Nvv8_vdXxXESuBqaiMUerzl.q7bVqh9.JisdRBrBhl16 .zFKFqREqGombVlRRtHaQtRaBl.yB.21iGx9Ns8JbtT31nkkYBqiEZSfZoQ8wB1K2YER7YsSCl4m X07NqohSxNbFYOnmU5SUOvi3Q..2VIsIzLY7jR65MXNycL6Dvk19E5TK582fZXbv688xbTvkwpzq .HpJ_ljlOlVx_kPY5Eh6ovTZt_Gd5zSo9Z6hp_3ohH81QLFfsGS0n..IXnZ6RFT_EbsRqHaa76me SUbifQmRS0STkC4hLdgnoKok.VE13oDra_n4KOHp6oasODO_gQwO.WEDNEukwM82_G37Edb8X.bc 1ND4YhXD0.95IngKD4neHRgBIlJIDr7Hafmo8xfpr5Rs7c60QTIsElH0wtITp5dUezGU8Ae66e2i 0pTLFJtKR2tZQPNzvMEHgQfBuNh51rc_CmjVX7F_.b18D7vUD_u9i7D.XCGaLbqw9oLHlDUslk.4 db13QG4TaDpeWbmsV4cqufxQn.NrZ.GVtXYFTIph_U4WRzvMf8.4oGAEb9NLAhjVmX.shfUsMNL8 D2GUcX2SpeQAigqgU4S.sIhFp2oWGg7avxcW8w79_G.JAh6AEYdyHXljT5IPlUHAMBIRgLI8pxxE uKOCcGW13zP0WjkZZkMdULevXK7kQA0K0mlnSAb5MSJP8Mz_GIhc11FOoRcg8vYw7x4td.kmuU1y km7Z47H753p8BJmokySUlmowLSf_eD8.4GlDNSWWonEElcOAbfkjghfvbaWI6bRQd9NDfJFCf40s PJhYZTh.V2hlOOffB2pLsT.7hEfrYDlLJEeIO7Vj0C9NN4I7iQhV1XUXoYPozmcLf488VhjU3VmF TYRjk9rR.aDD3UYbuhBoSy2CLQWtU4AlZh3_1rlGK45_2aerO72MDI.cctAzgBJmuGUUfKv.8ULx LX77YzVyyp6ijbFFMvHPBYBOrbLc9KEnz7qqtwDpTXQrM.51sr.InEEoHjHukN.wZc6Arhcz5 Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.bf2.yahoo.com with HTTP; Thu, 31 Jan 2019 19:42:36 +0000 Date: Thu, 31 Jan 2019 19:42:31 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Scott Ribe Cc: Pgsql-admin Message-ID: <729416431.1006652.1548963751866@mail.yahoo.com> In-Reply-To: <5D93F164-7317-43F6-B685-362779757250@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> <2031259937.990023.1548963344432@mail.yahoo.com> <5D93F164-7317-43F6-B685-362779757250@elevated-dev.com> Subject: Re: insert aborted commands ignored MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1006651_561707145.1548963751864" 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: 4884 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1006651_561707145.1548963751864 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable how to roll back?=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:39 PM, Scott Ribe wrote: =20 > On Jan 31, 2019, at 12:35 PM, Pepe TD Vo wrote: >=20 > that is the first error.=C2=A0 I get the same one over and over with=20 > ERROR:current transaction is aborted, commands ignored until end of trans= action block from the first one until the last one for each insert. Then you had a prior error, and are now continually trying to run commands = in a transaction that is aborted, because of that prior error, so rollback. =20 ------=_Part_1006651_561707145.1548963751864 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
how to roll back?
<= /div>
 
Bach-Nga

No one in this world is pure and perfect.=   If you avoid people for their mistakes you will be alone. So judge l= ess, love and forgive more.
To cal= l 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 = to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love g= enerously **Care deeply **Speak kindly.
*** Genuinely rich *= ** Faithful talent *** Sharing success


On Thursday, January 31, 2019 2:39 PM= , Scott Ribe <scott_ribe@elevated-dev.com> wrote:
<= br>
> On Jan 31, 201= 9, at 12:35 PM, Pepe TD Vo <pepevo@yahoo.com> wrote:<= div class=3D"yqt0016716121" id=3D"yqtfd88991">
>
> that is the first error.  I get the same one over a= nd over with
> ERROR:current transaction is aborted, = commands ignored until end of transaction block from the first one until th= e last one for each insert.


Then= you had a prior error, and are now continually trying to run commands in a= transaction that is aborted, because of that prior error, so rollback.




<= /div> ------=_Part_1006651_561707145.1548963751864--