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 1iIyA2-0003Qt-9A for pgsql-admin@arkaria.postgresql.org; Fri, 11 Oct 2019 16:53:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iIyA0-0002Aw-U7 for pgsql-admin@arkaria.postgresql.org; Fri, 11 Oct 2019 16:53:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iIyA0-0002Af-1s for pgsql-admin@lists.postgresql.org; Fri, 11 Oct 2019 16:53:00 +0000 Received: from sonic305-2.consmr.mail.bf2.yahoo.com ([74.6.133.41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iIy9w-0006mV-Ap for pgsql-admin@postgresql.org; Fri, 11 Oct 2019 16:52:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1570812774; bh=6ZykswCNeuG859/GDFavtlnjwlkiCz5g11vCCkBDOC0=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=ukm1ubbukZwCvDPuWZQO0GQtWNO8qpMA6NMGenBn4S90viMTvU/1bKwAQNgvex/lAKW1FFdYbAHVOKw/hjmdMXlL0EjsWm3bPQaTuopuVgZnI5hV83PqHvaCGMCSqXG1Nj9DkR5ZHTkYVaQp+TF+byTkx9sw5oD2Z4OILs/PRmh2yVdg8VM3EE84BMPc1tQS8xGPsaWRR8oww022/6mC5SnigI82Dh0R+6ZEbstK2yR5VkHLBuHl2wH+vN6fxKVlrdfSLeTFuBgnZ2HXCngtn9QjGTpxW1UDl2pAKD3FllWTHj2ANEsz3LbIPrXLFFniI/R9Le0Ospf7WdVHltcw2Q== X-YMail-OSG: N002KdQVM1lyRiVH1VBH4.Zvu_IzL0bNrJipYq17yYQuygHjp16dNH_iWRSw2us NBjxxRF1d_PO_3u6e8zzSBwltYt6aRav7e479gTUFItOEjirMDKjwbnS2WXKK0leRbYwoVjDWoU0 pg6eZWqOub72JCT2WDqDEUPcgbdVENywyDCQuFxmmHuBUtCMh7xgJ4DVQrFRm9TazSYkM_WV9q_x ZBN7bpcxj1hwy0F1inF2taKDKRimxAldF3WFEjcZl3Rjz7_g6dCMVhhGHFtKSgGufwypFhZWjGUB ya.L26G7OBDYcvrq.DTm9uBHLDa_PbAmFULY1Dyspu428A9ohdsb_ZPQw1jqLRkQLe1cQz70SfMW 50A5L8rQMlyTNww4uiU1ef7OuTcXwpO6l8K6zwW7sibiJIPb1YQFpMiHk3sVGbnPyVMSsumeE2TZ cj4c9bqJ6xYHM5G0ekUZDG5p5oIK.C5RnLLBFze9.jLYgx9ZZwpa.0h_dJdbuaCnGegbmMpay8tq m_jpFajZsbhUJ10HUwhVHbijoxUv8cLS9T0INg0vVuBJRdKs16PIEntikxss.2k6FZ2srFlg_uzC dUDBoZPfuTwAZVLxnQ6OrBib_biGexZdbl0rWRBiPrjAAsFSNvH1gDuzPYhBcw0f1RD_hEjYuRx1 6pLe_3Be.i1AT05rESp5zio8o4tuQ2PB4iAffn2ZMXlpzCKGOrkGRDDYnl5g8ita7C7AyzOFrVcM vreT86hoU9K3DFfjxyw_qTv7Hg1vYarc15uxYowFW5Njd.ejAW4vj_I7.dnux2dBm76xn1bVdK7f wFHq9LR81MnpuyfER939ZY1D8MVJOdSSE3raUImBg6W2d1Q6WKjS4rro8JaHV.qkajDEQn_e_IY. p4tNZdGq9O92UfD3Ko1ylMw5_eMtt05JhUwHRg3zfmUAmVZRSnQYY0MFEhuGEiCtRyUW4saCMjXr AeWfdX1zYM8AHJO..wJW9fJVrwWsoXaHx2D15iH3Jl2lbCMkVPR15XVddsOulzGXXB8FfN1OAYri 8eghJ0o2sE0LxfYFKPSJYPxHur39p_gozDiPnkc79zJWd6XVGULfBY8lSKo3KPPBQvYh9FT2K2XO YzNyqneauva2OXOAUpSVn1Kh5Na4J6zv.W3caSzZgxveh74mjzIb6OdvIzGzbpXcZ6GtX1Al7kkU O8CIoCCkLKew2brZAvOOGME9wxKMAjRpFRrVKr7bpra5d3MhsIydHNNUJ5.mwlSaju_HqnNEBt0f kJcu3UHLBe6qIh4plsD07G1x3RqYmDW4zjGopE8yzSkn9cnH3kLi3xdwluHMedED10xhQDxQMgk_ 01DmP0OcnHMm2Xe5FDaKEYd1GhB8- Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.bf2.yahoo.com with HTTP; Fri, 11 Oct 2019 16:52:54 +0000 Date: Fri, 11 Oct 2019 16:52:50 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Luca Ferrari , "Deepak Pahuja ." Cc: "David G. Johnston" , Pgsql-admin Message-ID: <396922018.196756.1570812770794@mail.yahoo.com> In-Reply-To: References: <1496660547.3525362.1570560989743.ref@mail.yahoo.com> <1496660547.3525362.1570560989743@mail.yahoo.com> <1899900811.3794492.1570631172044@mail.yahoo.com> <1943078548.4158063.1570716713369@mail.yahoo.com> Subject: Re: how to call a stored function on conflict MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_196755_1605598539.1570812770792" X-Mailer: WebService/1.1.14498 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 Content-Length: 11879 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_196755_1605598539.1570812770792 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable And someone from Europe advised me work around with my errorlog table and s= tored function. "on conflict" I played with the query first and make sure it work before cr= eate a function.=C2=A0 And the function created with output parameter. I moved my cubicle and the network log in into AWS is having an issue and I= can't pull the script out.=C2=A0 =C2=A0Wait until I have access to AWS, I = can send you a copy. 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, October 11, 2019, 12:27:05 AM EDT, Deepak Pahuja . wrote: =20 =20 Hi, How did you resolve it. Kindly share. Thanks Deepak Get Outlook for Android From: Pepe TD Vo Sent: Thursday, October 10, 2019 7:41:53 PM To: Luca Ferrari Cc: David G. Johnston ; Pgsql-admin Subject: Re: how to call a stored function on conflict=C2=A0Thank you, I fi= nally made it work yesterday afternoon. thank you so much for everything. 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 On Thursday, October 10, 2019, 09:39:45 AM EDT, Luca Ferrari wrote: On Wed, Oct 9, 2019 at 4:26 PM Pepe TD Vo wrote: > would you please tell me what the issue here? May I suggest to log the running queries and see what is effectively executing your function? Luca =20 ------=_Part_196755_1605598539.1570812770792 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
And someone from Europe advised me work ar= ound with my errorlog table and stored function.
"on conflict" I played with the query first and make = sure it work before create a function.  And the function created with = output parameter.

I moved my cubicle and the network log = in into AWS is having an issue and I can't pull the script out.   = ;Wait until I have access to AWS, I can send you a copy.

=
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 forgiv= e more.
To call him a dog hardly seems t= o 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)
<= br clear=3D"none">**Live simply **Love generously **Car= e deeply **Speak kindly.
*** Genuinely rich= *** Faithful talent *** Sharing success


=20
=20
On Friday, October 11, 2019, 12:27:05 AM EDT, Deepak Pa= huja . <deepakpahuja@hotmail.com> wrote:


Hi,
How did you resolve it. Kindly share.

Thanks
Deepak

From: Pepe TD Vo = <pepevo@yahoo.com>
Sent: Thursday, October 10, 2019 7:41:53 PM
To: Luca Ferrari <fluca1978@gmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>; Pgsql-admi= n <pgsql-admin@postgresql.org>
Subject: Re: how to call a stored function on conflict
 
Thank you, I finally made it work yesterday afternoon.

thank you so much for everything.

v/r,

=
= 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 hi= m a dog hardly seems to do him justice though in as much as he had four leg= s, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (H= ermione Gingold)

**Live simply **Love generously **Care dee= ply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Shari= ng success


On Thursday, October 10, 2019, 09:39:45 AM EDT, Luca Ferrari <fluca= 1978@gmail.com> wrote:


On Wed, Oct 9, 2019 at 4:26 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
> would you please tell me what the issue here?


May I suggest to log the running queries and see what is effectively
executing your function?

Luca
------=_Part_196755_1605598539.1570812770792--