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 1gpJ3O-0008Bm-UD for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 20:35:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gpJ3N-0003wA-7Z for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 20:35:17 +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 1gpJ3M-0003kS-QT for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 20:35:16 +0000 Received: from sonic304-12.consmr.mail.bf2.yahoo.com ([74.6.128.35]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpJ3J-0000G3-6i for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 20:35:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548966912; bh=vVXOgFQvMvgwPFctOAfdwiaOFkxt6+7/9JXg+CTVRMI=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=kQCAQwWk+5MOl42pxAaJYlMP1uvQSNsAXfaGOSHHnKQL+wRJA+wSWf1b60c67G4U1UllEDhKqqb4KKyoOtmP9jYfU4rJEF3Jd95nEoPgopK+lSWcPWMy1AM4RvBYCwN7tNiItwYHehggWcRKKpKFrJKCF2tyel31hN4ZCmSJ9EyUR/lsyDInTeoPYV0mNhMy0DafUrJa6ddUQ8npeG59ahyVA2ftENW4UC0rXsDT5RsY5Vq5Rtcqv2LcXTasemL1nWtrLQtza8jNT3t83H69p4ZSW3V82PxHmHvin2IxRaaBNpsVLwrDAvu67D5W7ca9dna0ZNxRzfN3Tej58Er1oA== X-YMail-OSG: P5dCXdsVM1lMoyj68Apqzxykzp_kuu1cTpXWepSCK52VAFWg0uMDE6_6AyJyzp5 vIfMYdsAFdc.QTW.7qsIVdv.mC.Dg8OXTQefISky2drQ7tpov9ZCBOzi8CZWWsFVQ9mD2C4ho0EO e6p.ItQ6RE2Rimf222nlIDcumhnzi9oqAtZ0iNkxuL1HYkDqBsUhitg0N8ACEEqs5gwzIWkRFm8X 01KJMGwsr31PRPqn7IZtR_0wL2cJXjpwF6dyQSxjaI1hvbZZfxD4Fy_9fNE4X9TiuMWeQ_._kx2a _5.lfriEmof68qzxfspStzfYGTdfsf0DXXzGUVCBA7da_Qw4je00CRP0_yo777mchM.0dp02.Qp6 KXewHyjfN6nhQCTVNxx8BAnHfhvlm3qnrxXYHo9s125VEHFdKLEVTUS5Vt5ZR4p4uU1qNkXmGpuQ 1jlrPJ1G0usj8Ozp9N334Yq7tyyOsoULL3L1WB5RoxYJW8ktqWr0Hc6Mnpeu2RE6p6dM8tzb5h0g xYH.YTbz7dxxkPXXKvdGWJIojLX762uyUjovWcdQZ2xLphKUvh5caZBWHcYto4FEdtl1FUySy.t5 Oq176XYmegoui314zYS84wQ1jcp2fZci2H5hya7KNwHNQb1AtTBJ8KX4xbCMjUSXLqr933_j4XN. l92OzTYUPHpfkeNoJoyt.FMU2789xLqebSyjroQVPjtWJf2hHKYzxFxByu_x13j_B8Jx30CBNUM6 hDa8Sf2akzYoGGIlfdiHGQsMunZEaB_auL17hSWD_1L0eLfywNEYmtpeJd884rvhlwTmECDNWamB KdlyTOsmqIj_R3gu2Y0k_7eTQa1f3waR7pPkHTBXapRjLm6WVeVQJe4aX2HeC0b6jgV..jEzJ4hr S3MaGXl.M4W2fKCNu9y72IY.5djgZLx65VQcisfZ3IT2rOhBwBeV9F0UpGJPVuXyAPtiPqGBUyXp B4I1TuDYDTq6QRUSNuJohDZ2f18xdFAAyhvUzm8MZHtjcgiLLknV3Ax8ongCnM17YsNTv1QoUO9K YmSm.asMIZF.pXzWI8briPFLny2o4QD636IB020Adw48bynfPTSrC2Y7R3dAy72i3Ovl0t5bY8A- - Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.bf2.yahoo.com with HTTP; Thu, 31 Jan 2019 20:35:12 +0000 Date: Thu, 31 Jan 2019 20:35:04 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Scott Ribe Cc: Pgsql-admin Message-ID: <890332297.1033268.1548966904362@mail.yahoo.com> In-Reply-To: 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> <729416431.1006652.1548963751866@mail.yahoo.com> <524354657.997228.1548963965240@mail.yahoo.com> <3842423F-D68D-4BD3-AB34-7508B01B2A9C@elevated-dev.com> <1225497522.1016680.1548965545454@mail.yahoo.com> <8004E05B-CAFA-4620-8E10-09A796064C9B@elevated-dev.com> <677786735.1029265.1548966193847@mail.yahoo.com> Subject: Re: insert aborted commands ignored MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1033267_1617192106.1548966904361" 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: 5765 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1033267_1617192106.1548966904361 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable here how I run the script $ psql -U postgres -d CIDR < insert.sql > insert_cidrmgmt.txt I got all repeat error ....."ERROR: current transaction is aborted, command= s ignored until=C2=A0 end of transaction block " even view insert_cidrmgmt.txt.=C2=A0 All the same.=C2=A0 There's not no oth= er output.=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 3:26 PM, Scott Ribe wrote: =20 > On Jan 31, 2019, at 1:23 PM, Pepe TD Vo wrote: >=20 > When I execute insert.sql I get the error as I posted. There MUST be an earlier error--that is what the error you have posted mean= s. Check the output from insert.sql carefully. =20 ------=_Part_1033267_1617192106.1548966904361 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
= here how I run the script

$ psql -U postgres -d CIDR < insert.sql > insert= _cidrmgmt.txt

I got all repeat error .....
"ERROR: current transaction is aborted, commands ignored until = ; end of transaction block "

even view insert_cidrmgmt.txt.  All the sam= e.  There's not no other output.
 
<= span class=3D"yiv3811552299sg">
Bach-Nga

No one in this world i= s pure and perfect.  If you avoid people for their mistakes you will b= e 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 outwar= d 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 talent *** Sharing success


On Thursday, Janu= ary 31, 2019 3:26 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:=


> On Jan 31, 2019, at 1:23 PM, Pepe TD Vo <pepevo@yahoo.= com> wrote:

>
> When I execute insert.sql I get the = error as I posted.


There MUST be= an earlier error--that is what the error you have posted means. Check the = output from insert.sql carefully.




------=_Part_1033267_1617192106.1548966904361--