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 1iCQZW-0003Rc-6O for pgsql-admin@arkaria.postgresql.org; Mon, 23 Sep 2019 15:48:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iCQZU-0007FR-Lu for pgsql-admin@arkaria.postgresql.org; Mon, 23 Sep 2019 15:48:16 +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 1iCQZU-0007Et-0j for pgsql-admin@lists.postgresql.org; Mon, 23 Sep 2019 15:48:16 +0000 Received: from sonic313-13.consmr.mail.bf2.yahoo.com ([74.6.133.123]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iCQZP-0003Rx-NK for pgsql-admin@lists.postgresql.org; Mon, 23 Sep 2019 15:48:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1569253689; bh=SgA2a8jEWDtxxNAOa04OZa3X6QlqNzSdqZJxwtyYZ2A=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=oD3tRtxKZUQXLJOwIMbLe99dBLRImdqmICkuk08CcwJnGyB+BaFVzELVmf7jwGOHIIscoYOJE2Vr8xguXndk6wzpC16GyTzBK7Y/q2i1DZcLw7v4+ErBVORg9gLeJMmx46RdXWilXRKeQ6p4khVsKM4imTHy2rDbjz3YLOtZouLKbpz9PXDMh3floLRfvPgXuk9VaIDPduSVJfqfSjniuH2m1au8t1dbBtmSXY/Ya/oDKSWyvTXR4auoRnrvXszusge9HdKUGmOQH6KhHE2lxLtP6O4Lje6cU3pq77+qs56wtnlGPM+Y7HxR7AYh2HBWOuunJZ9uuLM4rOSxu6xGZQ== X-YMail-OSG: s7EGzEoVM1ndENvmqotFkhVlW7SsxcbfhhXg9zClNU4m9dbzwyrQxQ0H5Be6U7Z WZbOokNCPlq0g1V8t3yjE9ybNQ833jV785RDEI7BaREwkvKiiaid0mHznq.9HV6nDzAVIAwpXfpv 8wZXPxhzgdQcyB_JbySqzw6qmb4i6ZqP67GmSrbLAW7qKO5jmpXIaxNbE6hE2ywlbFq_ILzEA.T8 ZiH9F9iORv5XQOnD988yHmKqraR9n9uhtHFKvlpAv5BnlS1VRRevykKjDSFkadge92f5SYwvfNCB zGV_BemP7zZBPSi2tYvcxkx1WNsuayT4oeAl4PW1bX3jxu3KpzUqisToFfPA_6kN25LRODz5x89c x.aUlAFEF_5P_laqz0BwxhokwfqJGhL5modDscw6oAGWzwnYUConP0eTS8Hcju1KA7toscsnosgK XM5c_DSu40jX.dVZZLojJvYqPUNNZj9xWk2ckV1ai1V2SxWceAQJUHlXhaHs5YqPhElUb9HTYlRr ib8gU21VO.1Ow73Z7gH3KxlJpukTudi6_BWp0aZZjmTP_UeSTDMvOmTvdzXciu2SaVkwXd4glsq8 xfyA05zp2OLuRoD6d7H1V2BEZu.j.MFhieKg3V3gPHEXkBFzJITshf1koQ1lUT3rsZlIS7Zsi9qi ORZS1DqXOnk5p4LrUx3Iu4jEm1ZE_3jfiY5rJ.pbfJI8IEjq2tCdbZJhtD3CxcYyKV1JW9diT7Ye FwFrh72TbiQKfRprLxQAQ50iZhtE6FkWai8a81EXOYmQQaBZv1bOkx5lGCeymXzBSb4mn7MWl7ET QtV2ItcK0fuL6KtPliFO.Vx2GebW0mtWsy3AZUqRiFOijS9aGy1N42Mq0js8vbc5i1VEgI83z6yE e_nyerGCQUuV8lzV8U4XPsB8wkL7X0EqqsOxKThD42qdDmFF8GBuQM_GXWaHv0miEWbOsFnxFqx4 Q15SE8wmkWl4Ws5eXd6OFhKaPgp.99mR.0wMPDdxvbL5AboEG_1KrvHBNuH_ZwDLcSQp5BsFWQlT cBrAaFdnhd6CS_dlnOHfo877g2IfteWfUfNhxEs9djaQ9r89J7fqamlHIeRGHICPA47GMq4yaTj9 IaDZ4wj.OJDv2IawvKVZaY7lDTsm0chNqXAsDctxrj9XjCfa3Ea4vuOcEMFQIZtA7vIlxGzxgzPg mzDTPQW1.i8OgxvqEmArFT_gmh2IovSX1AuYPxdgwnaWnjlDwmHB6gnAB1H036Lxzz7FtnWpvLr1 og0_34yDJmPbYPsQFTi7MdbAmlDOmm.SWGjCLios7hAbdZSoPJKFIJ8J6UOd4Z0VxGJ1m Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.bf2.yahoo.com with HTTP; Mon, 23 Sep 2019 15:48:09 +0000 Date: Mon, 23 Sep 2019 15:48:06 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Keith Cc: Morris de Oryx , Pgsql-admin Message-ID: <1484139594.7739085.1569253686831@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> <343266304.7137386.1569017757225@mail.yahoo.com> <647259260.7679971.1569249263294@mail.yahoo.com> Subject: Re: Merge statement MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7739084_807091345.1569253686829" X-Mailer: WebService/1.1.14303 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36 Content-Length: 11775 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_7739084_807091345.1569253686829 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Yes, I heard =C2=A0MERGE is not a command in Postgres=C2=A0but the others s= aid merge statement=C2=A0added stored procedures in version 11 I upgraded my postgresql from 10.6 to 11.1. in AWS, still not work. 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 Monday, September 23, 2019, 10:49:34 AM EDT, Keith wrote: =20 =20 =20 On Mon, Sep 23, 2019 at 10:34 AM Pepe TD Vo wrote: good morning, happy Monday. fyi, I upgraded postgres in AWS to 11.1 and the merge function for procedur= e is still not working. Still complained the same error that:=C2=A0ERROR:= =C2=A0 "ecisdrdm.application_cdim" is not a known variableLINE 14: MERGE IN= TO ecisdrdm.application_cdim prod=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 ^SQL state: 42601Character: 348 v/r, Bach-Nga As others have said, MERGE is not a command in Postgres. The document you l= inked is a development document from a long time ago when it was proposed a= t one time, but it was never accepted. Please reference the actual PostgreS= QL documentation. https://www.postgresql.org/docs/current/index.html If you need UPSERT like behavior, look at the INSERT ... ON CONFLICT statem= ent. https://www.postgresql.org/docs/current/sql-insert.html =20 ------=_Part_7739084_807091345.1569253686829 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Yes, I heard  MERGE is not a co= mmand in Postgres but the others said merge statement&nb= sp;added stored procedures in version 11

=
I upgraded my postgresql from = 10.6 to 11.1. in AWS, still not work.

thank you,

= Bach-Nga

No one in this worl= d is pure and perfect.  If you avoid people for their mistakes you wil= l be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as muc= h as he had four legs, a tail, and barked, I admit he was, to all outward a= ppearances. But to those who knew him well, he was a perfect gentleman (Her= mione Gingold)

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


=20
=20
On Monday, September 23, 2019, 10:49:34 AM EDT, Keith &= lt;keith@keithf4.com> wrote:




On Mon= , Sep 23, 2019 at 10:34 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
good morning, happy Monday.

fyi, I upgraded postgres in AWS to 11.1 = and the merge function for procedure is still not working. Still complained= the same error that: 
ERROR:  "e= cisdrdm.application_cdim" is not a known variable
LINE 14: MERGE = INTO ecisdrdm.application_cdim prod
        &= nbsp;           ^
SQL state: 42601
=
Character: 348

v/r,

<= /div>
Bach-Nga
=

As others have said, = MERGE is not a command in Postgres. The document you linked is a developmen= t document from a long time ago when it was proposed at one time, but it wa= s never accepted. Please reference the actual PostgreSQL documentation.


If you need UPSERT like behavior, look at the INSERT .= .. ON CONFLICT statement.

------=_Part_7739084_807091345.1569253686829--