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 1gpLgu-0007eX-LB for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 23:24:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gpLgs-0004D6-JY for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 23:24:14 +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 1gpLgs-0004Cy-0b for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 23:24:14 +0000 Received: from sonic314-14.consmr.mail.bf2.yahoo.com ([74.6.132.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpLgk-0003xf-Vg for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 23:24:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548977045; bh=z4oNcfQ7EDej1v4N8nwvGNeIiJjsoWLerSeuLa6Gt00=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=inFJbsDyqXi/crA5ZuE4UINheucBoSTXcJs2Qfk34PkNvkCnmKzTgPdhQJT9Cx4Cye3zblhMTsKGdbWMtiLVmrQjcEhTuYyGghpZ55CeLAGMlQXFyjlCQuZEd+UJ7bQK552oONgrd2C6Kr4QCDMmms1RR6W/fTABuiu0wdCDjKZLGm9/mOigjKM5GyVy0NZm62u7FTeBZICv7K6ZEAF2/I/CMXikye1V0clbsNCNan4rVU38vV5rCSL1IlHRBKj2jYDbCiyPxlG198O6guz8Q3+tgr4yiA3HX2dly32buW0m3somPQHCo3W6O2FlGsIsvS12XJ3stVPsuFHLDcsABQ== X-YMail-OSG: g8sOK2kVM1l9jQMIAfaDmH6fbdcom3vBJWEWm26BO66ZK4E8rOyLaZvqhA2doAB KeKNcoV6KLyXyCdcdR2JekZwx2jz30QvZZrfgRs1xLhlXChv12If_bf4E9RQrtUOvcyxT5UJhVDZ NMJla3uysGz2lblp1ULahl9zwnrkCJW24ivx5ag0rzT4F2oQD9hf6pesZv_KSgcmH8EpJYzfgFmV kJvu2OWNBKAjFWCZL7spioZdzfquxS7_dF37d.L1t2BHKjxkLGW56GSUU4lm6Od21k0IuVewLImF RKWA8Ah2Ni6TMVXFCTZ0APYrQVLc4wuF5iFMGm1CGWUio3qR7as_y_x41bgMW_fRn6V675MkP_KL dkH.ZQ5JFucuEAq32VOyfzRkE.zA3jZjDt1Uv30Xq1rAHEuh9x33eBnq4i3k4YhNx84bmLPGLdwT 6U2U06uL5vLxkNkCsEnG7ma9RNEEEIUidHYrNoJ.U8Ck3CQQEA9WD_LZYnMrDmCyJ_LtZHTacaka EnRUJQLpbz.FzWAdBBILnAzqhMgiqsHAiPw5iEeroDbQKd2QBoZYzpD5u8qXy0v_NPmj8U_Vw1oL 03UnQw9WFEzEn3F9tmG4MYsahnDtFj_lDox7lKMXhxmqbsBNdWlyj4ZTYwl6laaZsBOJIU5vgIkE U.c4zp1c8WE0qNbR1VsQ9b.TPspEGAoO05rhuTvkn68Bg.pstJ3MBL1K2obeUASV8s8uRJglProe Lxq.vEU4gzkTydUzFEuJwakMF5Eb4R5vb3LndbX1kQun373_CRJm68siA0EIL__R81V6XdqHMXt. 9l3lJuTB5gUp4akbOy.44lvIqOSp8VeKwcmvUfo.118SJ9jYacAS2PRap9zL.s7PW.HtxkTOyJ8x 3k.7TlMex.h7jfUrmjb1I4u1pKfxE_J1SODAKa4oiK4h9PjwvTv.BYJiNC42RtZQvvxbqYi5cNUi 9Zhts80JCBbaX6DBSDaGHEmNw11Y0zyquafZ6B.31LBc_ieDUf9UCnuFeME7ke0ooav14QMWWA6A GSZ72joryFBvBQWJnZAqC5nFF9Sm5eiGtwjzNBaJ1K_XKikHxgovBbHKbI5sahP6lsHms Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.bf2.yahoo.com with HTTP; Thu, 31 Jan 2019 23:24:05 +0000 Date: Thu, 31 Jan 2019 23:24:03 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Andrew Gierth Cc: Scott Ribe , Pgsql-admin Message-ID: <258949467.1109657.1548977043936@mail.yahoo.com> In-Reply-To: <871s4sa63w.fsf@news-spur.riddles.org.uk> 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> <890332297.1033268.1548966904362@mail.yahoo.com> <871s4sa63w.fsf@news-spur.riddles.org.uk> Subject: Re: insert aborted commands ignored MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1109656_848068757.1548977043934" X-Mailer: WebService/1.1.13027 YahooMailNeo Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 5373 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1109656_848068757.1548977043934 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thank you so much, I will run your=C2=A0command tomorrow. v/r, =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 4:09 PM, Andrew Gierth wrote: =20 >>>>> "Pepe" =3D=3D Pepe TD Vo writes: Pepe> here how I run the script Pepe> $ psql -U postgres -d CIDR < insert.sql > insert_cidrmgmt.txt psql -v ON_ERROR_STOP=3D1 -U postgres -d CIDR < insert.sql > insert_cidrmgm= t.txt That tells psql to stop on the first error, so you'll be able to see what the real error was. Your .txt file does not capture the error because you redirected only stdout, and errors go to stderr instead. --=20 Andrew (irc:RhodiumToad) =20 ------=_Part_1109656_848068757.1548977043934 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thank you so much, I will run your command tomorrow.

v/r,
=

 
=
Bach-Nga

No one in= this world is pure and perfect.  If you avoid people for their mistak= es you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice t= hough in as much as he had four legs, a tail, and barked, I admit he was, t= o 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 talent *** Sharing success


On T= hursday, January 31, 2019 4:09 PM, Andrew Gierth <andrew@tao11.riddles.o= rg.uk> wrote:


=
>>>>> "Pepe" =3D=3D Pepe TD Vo <pepevo@yahoo.com> writes:

Pepe> here how I run the script
Pepe> $ psql -U = postgres -d CIDR < insert.sql > insert_cidrmgmt.txt

psql -v ON_ERROR_STOP=3D1 -U postgres -d CIDR < inse= rt.sql > insert_cidrmgmt.txt

That t= ells psql to stop on the first error, so you'll be able to see
what the real error was.

Your .t= xt file does not capture the error because you redirected only
stdout, and errors go to stderr instead.

--
Andrew (irc:RhodiumToad)



=
------=_Part_1109656_848068757.1548977043934--