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 1iBQWd-0003AJ-Lo for pgsql-admin@arkaria.postgresql.org; Fri, 20 Sep 2019 21:33:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iBQWc-0000qE-BV for pgsql-admin@arkaria.postgresql.org; Fri, 20 Sep 2019 21:33:10 +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 1iBQWb-0000q5-LP for pgsql-admin@lists.postgresql.org; Fri, 20 Sep 2019 21:33:10 +0000 Received: from sonic313-14.consmr.mail.bf2.yahoo.com ([74.6.133.124]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iBQWY-0006Rk-Sf for pgsql-admin@postgresql.org; Fri, 20 Sep 2019 21:33:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1569015185; bh=LhwqovkpzIZ9eFIbCGTaoVnl8ClJ4gXQMtzDesTpgTc=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=UIw/0kz2+Kr163Pd8GqQhRiO5TYNwulQz+zPdhozDjd0AjlEJcmh+tK2hy1ft62MuL6AiByjO+edUpMHbcsAMNPzsBaOQW9IBbW+3eOgpkjQu3d9ntfQdTDJanuMxirregYFrl5HS5vZZqVTWzCQr5o3h6KWbvp+UorkLG5aNThG80AkbC2JfJGKUzLHl/hxrAvP9em40KfE5u7BUkLyVHoLejxNBgMi+PK+9tZTNHIWh6g5OmGNqt29+1IBt5CKPcFoxZqnBxfWWNfhMme15vbZyzbz5TUk4YK42M1+Ai6kYVhS8IWKze11dTnOVqj6370y36KaMMz1bmlL/9Ru2g== X-YMail-OSG: C78pZoYVM1m6XxkHqJSJ1.uaVMK_3cupojGpjfJ832VKf020ctKZYEiWBJu.gMA m6kPjGoXAPwM02NmePzLUeKtNcYBfG3tCYdCQyBlPgDG0dwp7K1WZK1xA7a7eMM8QEUAJxc8EfPl UryNkF4lCURW6K60Y_emHMItnFKbUMW.uCE6Nm.YZn0JiRVgVkIhoNIU8EiLAblF6IQh9ZzOlswk mCgxBcbrZrYoTE3QMxE0sIKMCh3Y1QcAhAILxolGFlHps5iNlJtO2nCoihfnCklSiStNoFF2UyP3 HbinpxpQPQVPZPZlYoDGNg2fX_h8JwqojQTWtD5_eqPguJ2Td4N1sGCkqkEBDdM_I8hwgUIBSr1z 9Wtnnko623oIqOfjj7Y4OISBZsWBCac_8oMFH7rlOvwuMAcoOu_mdt4GGVL8WiXYg63j9AXl08N3 fear6ue5IvSEjxAjTysXnlVE9WH3h9cVQidvN8x54QuL9MPd_xU_Pb7jrm0qwPY4yCAswxW1H80f 1dwDr7COkjPbF6r5J6WDA3N3D1ZR1.ViKjxvYmuDTeq.RsdhfXo9TCGAHP8H170sDgmdt6e_8gy6 3Gt08NVKU3VA98yW0BOvBTsP8QU5FtpUaaxr6cgNBo5IVFsOl4OyZGgpnpCW2DvjmzvWdnwRLDRK WBy50cQsPb8Q1lT.NCyUSxn3sxOEeKV8AxyWjII2vYXTxQzERMExEXoRHQyafgVsEDHszq7Q0qG9 bkTwBH2KGQva.6GtGQjx5l9ai2DvVIeNJcGNDi3kM_fK.xGBQkG.hXhlU2PZRD3C931zP.dgtOfW LZ.4OyaZyNoFqlchEM8eMhHIDm2ZUwGzetgWxtVb9Tj6cSPBFMooXlUXRMFi4L6GZL_ItnQvxlnw laMrZ.mB2jrl5KLI44zL3saJt0QYBO0cUb2SnoF5u2hkRAN_qDgu.5A9w.zLYyGk5htJaLaLwb0O UEF_KLH32bf8EDJ1yP2rurTcIlKNvUDsm94ZW6rUWT0RqOhLqjAiaIG24VBDeOh6cj0ucQ9TRRMU Y8R369IuMAvdNhdyxtjp4wPfNvlSoFFki8gRcMpiigJPJajPZ96i58NRZG9D9xczDPWKFb4V1zf6 _qrsaiBRKorN5EIgFMY3tkyfFTm83IGBJ.ggU309fVu8GSg7kCsCpl3wo.stI.0JbUqRtwDNeNgv XJLZYsNOX_0.PgKuXkKsROTTwm6C.D3tEGsvIJP3DJZrnffBPqdtolqO2QZLlK_Aq59uzi1e0VIE UzKS9fhRqIW0gelF7tw8QJe1.s9plToBOcLyhhzbMxVh6JmW7CX5neie9_3iwhA8C87KN9g-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.bf2.yahoo.com with HTTP; Fri, 20 Sep 2019 21:33:05 +0000 Date: Fri, 20 Sep 2019 21:33:03 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin , Pgsql-admin , Igor Neyman Message-ID: <567497570.7112630.1569015183464@mail.yahoo.com> In-Reply-To: References: <290131249.7032562.1568999216076.ref@mail.yahoo.com> <290131249.7032562.1568999216076@mail.yahoo.com> Subject: Re: Merge statement MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7112629_931003607.1569015183462" X-Mailer: WebService/1.1.14303 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36 Content-Length: 12250 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_7112629_931003607.1569015183462 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable yes, this is to migrate from Oracle to Postgres.=C2=A0 I followed this link= and as same as ora2pg MERGE |=20 |=20 | |=20 MERGE | | | thank you. Bach-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 Friday, September 20, 2019, 02:21:49 PM EDT, Igor Neyman wrote: =20 =20 #yiv7064530853 #yiv7064530853 -- _filtered #yiv7064530853 {panose-1:2 4 5 = 3 5 4 6 3 2 4;} _filtered #yiv7064530853 {font-family:Calibri;panose-1:2 15= 5 2 2 2 4 3 2 4;} _filtered #yiv7064530853 {font-family:Verdana;panose-1:2= 11 6 4 3 5 4 4 2 4;}#yiv7064530853 #yiv7064530853 p.yiv7064530853MsoNormal= , #yiv7064530853 li.yiv7064530853MsoNormal, #yiv7064530853 div.yiv706453085= 3MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:N= ew serif;}#yiv7064530853 a:link, #yiv7064530853 span.yiv7064530853MsoHyperl= ink {color:#0563C1;text-decoration:underline;}#yiv7064530853 a:visited, #yi= v7064530853 span.yiv7064530853MsoHyperlinkFollowed {color:#954F72;text-deco= ration:underline;}#yiv7064530853 p {margin-right:0in;margin-left:0in;font-s= ize:12.0pt;font-family:New serif;}#yiv7064530853 span.yiv7064530853ydpa47aa= d4yiv3811552299sg {}#yiv7064530853 span.yiv7064530853EmailStyle19 {font-fam= ily:sans-serif;color:#1F497D;}#yiv7064530853 .yiv7064530853MsoChpDefault {f= ont-size:10.0pt;} _filtered #yiv7064530853 {margin:1.0in 1.0in 1.0in 1.0in;= }#yiv7064530853 div.yiv7064530853WordSection1 {}#yiv7064530853=20 =C2=A0 =20 =C2=A0 =20 ERROR:=C2=A0 "application_cdim" is not a known variable =20 LINE 13:=C2=A0 =C2=A0 MERGE INTO APPLICATION_CDIM prod =20 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0^ =20 SQL state: 42601 =20 Character: 349=20 =C2=A0 =20 =C2=A0 =20 There is no MERGE in Postgres. =20 Is this migrated from Oracle? =20 =C2=A0 =20 Regards, =20 Igor Neyman =20 ------=_Part_7112629_931003607.1569015183462 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
yes, this is to migrate from Oracle to Postgres.  I follow= ed this link and as same as ora2pg



thank you.

Bach-Nga

No one in this world is pure and perfect.  If you avoid people = for their mistakes you will be alone. So judge less, love and forgive more.=
To call him a dog hardly seems to do hi= m justice though in as much as he had four legs, a tail, and barked, I admi= t he was, to all outward appearances. But to those who knew him well, he wa= s a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deepl= y **Speak kindly.
*** Genuinely rich *** Fa= ithful talent *** Sharing success


=20
=20
On Friday, September 20, 2019, 02:21:49 PM EDT, Igor Ne= yman <ineyman@perceptron.com> wrote:


 

=20

 

=20

ERROR:  "applicat= ion_cdim" is not a known variable

=20

LINE 13:    = MERGE INTO APPLICATION_CDIM prod

=20

      &= nbsp;                ^

= =20

SQL state: 42601

=20

Charact= er: 349
=20

 

=20

 

=20

There= is no MERGE in Postgres.

=20

Is th= is migrated from Oracle?

=20

&nbs= p;

=20

Regar= ds,

=20

Igor = Neyman

------=_Part_7112629_931003607.1569015183462--