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 1gpIrr-0007GC-Ka for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 20:23:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gpIrq-000835-8P for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 20:23:22 +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 1gpIrp-00082y-TL for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 20:23:22 +0000 Received: from sonic310-14.consmr.mail.bf2.yahoo.com ([74.6.135.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpIrn-0008RD-1M for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 20:23:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548966197; bh=bpB0tCkh/3KVfcnKUC41EN4apUXRvBJDnumXIGvqkZw=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=a9np5CzD+HrzGZahtfJ9/wuypxc5HIM9vb2zbJ85otYVpcGReJ0l9r15Ub4+lXYprRwtXxt87wudVhQHVdh/i/XOzcFmJd0/qczt3FIZfZAAukH4e0ui3kHv976iWi3inqnuBv/Ij9Oc86q8PHa0UqjQOh82yXu0kGZt9aHTld6WCbAx9AGJH2WMeNFGZzld8b25mRW4TTu2rQrwvIg8xe0llMT76sIuIh3JbUnGlqfDhWm0KqdMDS2NJCfBuCCptQcsccAw/52bagM27NP10PhdhFHZcyLAzTcbPpkp21d2YIrsCsSZ/aEe3+JkVE59bKbLVsQePid0V6pjFAGXvQ== X-YMail-OSG: KJoTO_kVM1kU_3JnkjTuIU08aZ8C5WFYxFyBeL1ISDqLerDteYZt_Zi1cGR9suD QojOem1DczXUFINHQVDgT0FpypAQ4LSlyNeeXxRNns9B9AfTQYsTlOjx6aFOpJXtzUmFfq.Qu5Q9 2Zvn5ZESqst8huHD70dEOqK.7z2qXLYVmUGnFazt9wd7oCEsTYN7r.6VfrVFokBASmasOzOtf52h SM63zKX_nBnC2Cs.YhyKLSYrDlElthV.yA.lJGFk7lsm6UPKOG.GFqerOJCo9wuNYXq0jpmCfrPq UZb195eiHt6qmXghKO2opANBF7nATN.KZi_Z2fWyV.jmFa91fjPrKUC91n1Cu6dsfgHxA4BGmH5K 8NiCkJdJIh0VBvvdP.fE_wEP0vE.fYazDdD9CkA3p7bbjtoDOg1gCB_LkIyy5GzdNjcmLf0Bn53L n_w0BIRFzSJNlmDROOwS93AbFt3SaZwH2lkvg.AFQ96R_XKUuQ3iYlhQl9ooULISD3OctdEsWqHV KZWnSODdLLGtWJ2.JGsWlSwSRTpPAlIgJB33J2QUdVY1Src.WEa6TGftx63vtE2xuD5eXFUv.Uwr HmNh4ZMKcPaqWZ.RbODywtWm0FGa.yC1YPu77X_H6RrBMpd6vMHYf5xqMmVo8qEGKaAh_1ajWqUB HgERXYIGECuBH6hV2oRsxfOCkbfTxSbKq7iLnS_QmWJu4o0blQA.Zg8X33SBZ9MXyiId6kpo5ZFY qMR2hClGCm8fPXPEdAn240ly9CsPXd2F9Epz4CSefc5Nx1DyZoRK1nBgOm9jMhP6yWj7dmyN4a1s NGquA9XBMOdvb5lX35FESpCsVvd21sk1_ifi5zPufaaWhjYukE_55HIxGml8l73jzqN2vs4XOr79 prERPdXzKccPDOuksMwe0PpKRyfCn8st6vvBE_SAoFsyd.LnWncA54o8j2GB2YiPwBxyovR5_cWw TezH_HJtPBYHqV7DIWk9EA.sSlymg4VYXXbh_GEEoud0jKZzU2rb_RbBxFsWmxjuFxJYEBAuGXk7 5t.2paAZAO0fd3pXBro2eZt_vcpyAIUfRoeQbQ1GO8WlfU2jORUV3Zqpx5nMIGBLxG0OZt8Jw Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.bf2.yahoo.com with HTTP; Thu, 31 Jan 2019 20:23:17 +0000 Date: Thu, 31 Jan 2019 20:23:13 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Scott Ribe Cc: Pgsql-admin Message-ID: <677786735.1029265.1548966193847@mail.yahoo.com> In-Reply-To: <8004E05B-CAFA-4620-8E10-09A796064C9B@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> <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> Subject: Re: insert aborted commands ignored MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1029264_2091261032.1548966193846" 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: 5420 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1029264_2091261032.1548966193846 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable there's no error before I run insert.sqlI exported schema from oracle using= ora2pg, I imported (by runing) tables.sql, procedure.sql, sequence.sql fin= e.=C2=A0 When I execute insert.sql I get the error as I posted.=C2=A0 Check= the tables, they are empty, no data insert. Rollback, - no transaction in = process. 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 3:16 PM, Scott Ribe wrote: =20 > On Jan 31, 2019, at 1:12 PM, Pepe TD Vo wrote: >=20 > there's no transaction in progress when i type rollback command.=C2=A0 Al= so, all tables are emptiness right now. then there is an earlier error when you run the script =20 ------=_Part_1029264_2091261032.1548966193846 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
there's no error before I run insert.sql
I exported schema from oracle usin= g ora2pg, I imported (by runing) tables.sql, procedure.sql, sequence.sql fi= ne.  When I execute insert.sql I get the error as I posted.  Chec= k the tables, they are empty, no data insert. Rollback, - no transaction in= process.

thank you,
 
Bach-Nga

No one in t= his world is pure and perfect.  If you avoid people for their mistakes= you will be alone. So judge less, love and forgive more.
<= font color=3D"#8000ff">To call him a dog hardly seems to do him justice tho= ugh 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 g= entleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.=
*** Genuinely rich *** Faithful talent *** Sharing success<= /span>


On Thurs= day, January 31, 2019 3:16 PM, Scott Ribe <scott_ribe@elevated-dev.com&g= t; wrote:


> On Jan 31, 2019, at 1:12 PM, Pepe TD Vo <pepe= vo@yahoo.com> wrote:
<= br clear=3D"none">>
> there's no transaction in pr= ogress when i type rollback command.  Also, all tables are emptiness r= ight now.


then there is an earli= er error when you run the script




------=_Part_1029264_2091261032.1548966193846--