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 1iBRC7-00050i-Ji for pgsql-admin@arkaria.postgresql.org; Fri, 20 Sep 2019 22:16:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iBRC6-00028c-EO for pgsql-admin@arkaria.postgresql.org; Fri, 20 Sep 2019 22:16:02 +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 1iBRC5-00028C-Ly for pgsql-admin@lists.postgresql.org; Fri, 20 Sep 2019 22:16:02 +0000 Received: from sonic305-3.consmr.mail.bf2.yahoo.com ([74.6.133.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iBRC2-000758-NC for pgsql-admin@postgresql.org; Fri, 20 Sep 2019 22:16:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1569017757; bh=99x/jSlKmsNYCCAUq5p1Z/3x2gMTGc2nhFmpvxH6Rjo=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=M5nYCJs7dFT6OPbwwof2DasvV3bOm5llSWftBz7qqE0Gns5fmjVH2boF2r3sDltYDvxNgb38hEo8D+ozOc5rpHQZP4ryRNVztQfzPQUwIxjIsZIVB9uT7W3gUtmn23njB2iZM/I7PhN31Xgf8dy2jHLmwE41q5774IQ8GfXBvAQsR1eB4FVvCa6lg26arIShoFbOgagZS+grY2qzsEj7rwHmT1Lk8whaZeJmPfpp5oBu5w+3cEs3G4AHCQr0QUw3bUVJ5fFaJr2zPpr/4KmIi2FsxfM2vjPchmqeVls/XLP9DgNa0NsnWRBETyYnqhP0zn4549pExp2mukyOgtOWxg== X-YMail-OSG: AJAb2WgVM1m8t_cog3szifNR3WGuu2.yRpAcwnwV663FECPQci6KKTh6rHPHbjN _sW00V3w8V2T2nxW044WuWG6k9WwUidF7qVDOc91uFndpKlHDCGwXXe9dEj3DRNVSFSjlUuUpOdL pNAZ9F.hH6qMkP0iaRlsf4CDVuNuKd9DDOCkiRrT_1RMuGBBwm78.50qRtF24K56icaBkSfBaXZP M2QoIj4CBEIKUh1ox52SJe6Zli.JvbvNf.O3TFpYzo7PynTxvQOtWkklpq.Kt3SvMLwTFOY1xnpN rRzN205sPYqobSOw3wnXmPGwtmHfp7h5ii0H6cjWhYzxJpcBU6uOJ1GabypMTHSs5nYgdSnHXjCs 3n23sriQ7apKmE91b4NOovMPHTpxf18vzdqrAsKNbceRYIwCZhOQeZ4V9snQUyOvv00kH4tnMnTK lNvK3KWnazZmSLJGkTdVnd6cy3fxgwMcpPWuKVCTkasQq._HtGOmdvSexCht6G_VMXFriJ02oATZ jH_WP3YDE95kLZFq1sKZ2MQp6hK2vbb8nNUZez1NYA7OipNWFhDD5zTp7ee0fQIaoiKURAe7JCZI kldLLsKD.kH7lMk3WC0xvKL2pr8czcAUH05JABbH8CaIK5NV_T9XoG5h0ABiGLQyzL.glJkT7.wQ ui4FfVO_EOwdKCOaDuNpoHj_YJ3.U9knaj0Wk_vRDvelM3L67FlQlYFIy2hFG0hO1xldz866qMp4 aA.Fhfe96t_wYltvXGw40_E3wYS70JEViGgqukUlg8WAFBlmjsF6tlHkrIP_IKraIcT8ANk0VjyI QJt0eYLKlSQlu8QZ0DywU_0F3IcAs6o2ADREmtat5qge22dGxYfMAT8JygFfqj4F6iNyt8grSUUU 3yduh15tP4c3ii4fCPE2SRuYSJMddolgr9qUORFDTlywpCGmmUPODLM3bO.N4OUmTk_m8FsTCOm2 tjnXQ.oBKRDBdkUHAXWxtRHL7c4mqrr6WIrZoQFy2nQViEwQ3nX6dPXCdVHkolQ.K5B0__7k88Am 0uW1NkY22AzJH0kJVeOzreShTIHjZm28SxihKAQR7xOwkuOu_nSyJkDg2z_uFOQkvXQQ5Iu.1gLK nx_D5mEU38wNLYAWHysJn._hUDmzly0ItzixQJEqJx4nStR.tJmh3cOG66td9nAoeX5B76SzQCOx UFTBd8h1N2fCwsbmmUNUHt.MP8qGZQHg522C8rrbCUufx8tuzeHHqarAz6qgtFVciYUvR5KrvTeF IDk__KbAaTfWly9DlKtmSd10KC7gl6O2D0V6cF3nKpT23hyt1_4mAhJPfJPmsXZ3swF8- Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.bf2.yahoo.com with HTTP; Fri, 20 Sep 2019 22:15:57 +0000 Date: Fri, 20 Sep 2019 22:15:57 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Carrie Berlin Cc: Igor Neyman , Pgsql-admin , Pgsql-admin Message-ID: <343266304.7137386.1569017757225@mail.yahoo.com> In-Reply-To: References: <290131249.7032562.1568999216076.ref@mail.yahoo.com> <290131249.7032562.1568999216076@mail.yahoo.com> <567497570.7112630.1569015183464@mail.yahoo.com> Subject: Re: Merge statement MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7137385_1509755579.1569017757222" 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: 18273 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_7137385_1509755579.1569017757222 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable you said, I can use my script transaction processing within a Postgres fun= ction in Postgres 11? thank you, v/r, 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, 05:41:21 PM EDT, Carrie Berlin wrote: =20 =20 There is no transaction processing with in a Postgres =C2=A0function until= you get to Postgres 11.You can run a merge in Postgres directly through sq= l. On Fri, Sep 20, 2019 at 17:33 Pepe TD Vo wrote: 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 =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 =20 ------=_Part_7137385_1509755579.1569017757222 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
you said, I can use my scrip= t transaction processing within a Postgres function in Postgres 11?

t= hank you,

v/r,



Bach-Nga

No one in = this world is pure and perfect.  If you avoid people for their mistake= s 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 ou= tward appearances. But to those who knew him well, he was a perfect gentlem= an (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharin= g success


=20
=20
On Friday, September 20, 2019, 05:41:21 PM EDT, Carrie = Berlin <berlincarrie@gmail.com> wrote:


There is no t= ransaction processing with in a Postgres  function until you get to Po= stgres 11.
You can run a merge in Postgres directly through= sql.

On Fri, Sep 20, 2019 at 17:3= 3 Pepe TD Vo <pepevo@yaho= o.com> wrote:
yes, this is to migrate from Oracle t= o Postgres.  I followed this link and as same as ora2pg


<= a rel=3D"nofollow" shape=3D"rect" class=3D"yiv3779280792m_39664985353820492= 52enhancr_card_9644893229" target=3D"_blank" href=3D"https://www.postgresql= .org/message-id/attachment/23520/sql-merge.html">MERGE



thank you.

Bach-Nga

No one in this world is pure and perfect.  I= f you avoid people for their mistakes you will be alone. So judge less, lov= e 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 appea= rances. But to those who knew him well, he was a perfect gentleman (Hermion= e Gingold)

**Live simply **Love generously **Care dee= ply **Speak kindly.
*** = Genuinely rich *** Faithful talent *** Sharing success
<= /div>


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


 

=20

 

=20

ERROR:  "application_cdim" is not a known variable

=20

LINE 13:    MERGE INTO APPLICATION_CDIM prod

=20

                    &nbs= p;  ^

=20

SQL state: 42601

=20

Character: 349
=20

 

=20

 

=20

There is no MERGE in Postgres.

=20

Is this migrated from Oracle?

=20

 

=20

Regards,

=20

Igor Neyman

------=_Part_7137385_1509755579.1569017757222--