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 1gpHne-0003sk-Df for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 19:14:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gpHnd-00039D-0X for pgsql-admin@arkaria.postgresql.org; Thu, 31 Jan 2019 19:14:57 +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 1gpHnc-000395-8K for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 19:14:56 +0000 Received: from sonic302-4.consmr.mail.bf2.yahoo.com ([74.6.135.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gpHnX-0006nS-UY for pgsql-admin@lists.postgresql.org; Thu, 31 Jan 2019 19:14:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1548962089; bh=CkzrCofRaeF4EUI5dgOwAXKB8WGA1Kppg6TX8vOXPOE=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=hhTkP5YpVdKN7VEH+l7AqQDsSg67bSBg9EHqJGZuX31eaZei0QEMn8DI9IoYm1fiUAQ/jS2UNva3cotR9xWhr4SQMpF7NBwhLihV8LVjsFXO+LJ7tCb6sX2NwStrurfotvWfA/Dwn/u5YzlLvy3gHcfVtcfzRAW9wHOUZBo+V9E7ej4t4rLIXHMn22PCRWur8BHkbXjKxk3hWRQONbzFZHQgwhFBYhU8F2FAm4XU4FQwP9N9V490lU58CkTVSyuKQc5HnmdHIxRk7pUFXJZaVMofnH9iBJXc1Q1eMIEnWFJSnfAvTQo1NJO8nsm4BtMJFMu3DnaLAOU2wWKADbWlvQ== X-YMail-OSG: BvTds7AVM1kKdHIJaw3TNnkP6KmI5HoszRCQieuaO6RwtHulo8v9RlZpuiY7O6Y YVQTosN4143Papswhixf6Uj1c74.Va2uwztKS3Ds4TZ5eK8WU0a29OQ6Ia0jChle0YXWfbW_rDfD zkHIq1pXIsqCo9h0G7jGUZm.7T98RR8ZRrVW7OxNYi6pK9ls36BkCG3PQ9bLc1a6SYS.01y12zFx oZctg5TY1uBc86LkR8aBzLOFPnJ8TcQhC6sEWXVBxokYtDw1xyxcv4_nOK19v0Vi43QkxqcleKu4 gHkJnHPROQTcziXlsLZg_ySGlFqJC15d9_MaVZscJK4DcJO9uyoz_9lRFZQ0D8ZEjHWVacWZA7t1 wYl8X_O2.w2epLFz5q8l4UemxKRykO2utLfVIV5O5hbAX20A0.JdyT.DJ26aQrsAd0oNe6Ym7Z6y 1icZbTtLpFDRXrQuOT8k8GOQDQCZuom7pXy_yLqmcWHShjDJWAcStX3g6Ri.ae9e6AqL8SZ65OcX H2MoSVTssigDBM9XtcloH6VTQsIqCJiLgSFdbNDg3Nghrsc4.8ArfBplYFI.U3_AmxLxZJnZcWJk eKj512j0FJkt9ywfoNpsO9PmpMCE1il7v2GXp6sW6wybF8HuqI17pZICnJcTwmv4pJK5DsxHTlqy EZ5oJsGjz4u9hBKK4gP8K8n1BCZD1DYgQQsztgW143iBwQ.65fSEeXgjCVQBq130QqsT58JjMGTF sQ47ouLwmrYRchnGPE9oXjxK3cUdnStRYvv6HbtDSM8NaQIjJGpqIFDBZpoc4wsJams1B2_1kPsC RnCn7oEbxCZ2LVNFhSoNRqt6.._M8P7LB9HXPBmQLafU.H4vn7RjfleRFhjHJ8Ie1iaNFh0974VT ES0CI7_2nqyeg03s98CfHgC2yJJCTpvcAy3yReT57zRXTWqc1dK6uV6suXioPTOZdGsXAmvg5.Jj Co28rOB40ocfKY7qWh2SwXT_xoC.gzLl8hLTN_DgV8QyuTqj7godFjYGNH8v7LJwz7kAitdZ3E_y CBxBMXf0NIkFHLM4bfeaKajcYogE9tQReA_71_997z3gTPNu.RZo- Received: from sonic.gate.mail.ne1.yahoo.com by sonic302.consmr.mail.bf2.yahoo.com with HTTP; Thu, 31 Jan 2019 19:14:49 +0000 Date: Thu, 31 Jan 2019 19:14:47 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin Message-ID: <1861353148.992207.1548962087385@mail.yahoo.com> Subject: insert aborted commands ignored MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_992206_1433176132.1548962087383" References: <1861353148.992207.1548962087385.ref@mail.yahoo.com> 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: 6850 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_992206_1433176132.1548962087383 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello expert DBAs, I get the insert script from ora2PG and when I run the script, I get error INSERT INTO cidrmgmt.search_results( id,scheduled_search_id,people_doc_id,r= eceipt_number,form_number,a_number,first_name,middle_name,last_name,date_of= _birth,dod,gender,country_of_birth,country_of_citizenship,country_of_reside= nce,street,street2,city,state,zip,provice,postcal_code,country,res_street,r= es_city,res_state,res_zip,res_province,res_postal_code,res_country,ssn,tax_= number,firm_name,service_center,last_indexed,ds_name,applicant_type,doe,cit= izenship,agency_code,tap_number,classification,mf_a_number, mf_first_name,m= g_middle_name,mf_last_name,mf_agency_code, mf_tape_number,mf_fbi_result,mf_= classification,indicator,inserted_date,updated_date,deleted_date) VALUES(48= 96,92,E'7fdfcd2a-2da2-4f9f-bee3-4417a56c1a00',E'EAC1390072161','E'l130',NUL= L,E'JIEMEI',NULL,E'XIE',NULL,'1960-07-21 00:00:00',null,E'CHINA',NULL,NULL,= NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,E'V','2017-1010 22:43:16',E'C3= ',E'Beneficiary',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL= L,NULL,NULL,;2017-12-19 01:32:26','2018-04025 01:31:50','2018-01-11 01:33:4= 4'); ERROR:current transaction is aborted, commands ignored until end of transac= tion block I see each column has extra E' in front, is that right in postgres?=C2=A0 H= ow can I prevent this issue? thank you for your input.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 ------=_Part_992206_1433176132.1548962087383 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello expert DBAs,

I get the insert script from ora2PG and when I run the script, I get error=
=
INSERT INTO ci= drmgmt.search_results( id,scheduled_search_id,people_doc_id,receipt_number,= form_number,a_number,first_name,middle_name,last_name,date_of_birth,dod,gen= der,country_of_birth,country_of_citizenship,country_of_residence,street,str= eet2,city,state,zip,provice,postcal_code,country,res_street,res_city,res_st= ate,res_zip,res_province,res_postal_code,res_country,ssn,tax_number,firm_na= me,service_center,last_indexed,ds_name,applicant_type,doe,citizenship,agenc= y_code,tap_number,classification,mf_a_number, mf_first_name,mg_middle_name,= mf_last_name,mf_agency_code, mf_tape_number,mf_fbi_result,mf_classification= ,indicator,inserted_date,updated_date,deleted_date) VALUES
(4896,92,E'7fdfcd2a-2da2-4f9f-bee3-4417a5= 6c1a00',E'EAC1390072161','E'l130',NULL,E'JIEMEI',NULL,E'XIE',NULL,'1960-07-= 21 00:00:00',null,E'CHINA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NUL= L,NULL,E'V','2017-1010 22:43:16',E'C3',E'Beneficiary',NULL,NULL,NULL,NULL,N= ULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,;2017-12-19 01:32:26','201= 8-04025 01:31:50','2018-01-11 01:33:44');

ERROR:current transactio= n is aborted, commands ignored until end of transaction block

I see each column has e= xtra E' in front, is that right in postgres?  How can I prevent this i= ssue?
thank= you for your input.
v/r,
 
Bach-Nga

No one in this world is pure and perfect.&= nbsp; If you avoid people for their mistakes you will be alone. So judge le= ss, 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
------=_Part_992206_1433176132.1548962087383--