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 1iIZAh-00065H-Jr for pgsql-admin@arkaria.postgresql.org; Thu, 10 Oct 2019 14:12:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iIZAg-00068W-9I for pgsql-admin@arkaria.postgresql.org; Thu, 10 Oct 2019 14:12: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 1iIZAf-00068M-Na for pgsql-admin@lists.postgresql.org; Thu, 10 Oct 2019 14:12:02 +0000 Received: from sonic304-9.consmr.mail.bf2.yahoo.com ([74.6.128.32]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iIZAc-0001FX-Rt for pgsql-admin@postgresql.org; Thu, 10 Oct 2019 14:12:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1570716717; bh=ZwYVqDkvsp8h0+tFkaMms7scnDJuEeuzNeVyJnnAYmE=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=CKkpC3LFqRPKxAfk9TpIy+J8oo7fEtyNas30vER5GHg9TWmu4WAJBKbmqDwE0LZ88wVf10r+gjojVE1pjMd9pJchp1Ajy/sXBVIp4SC+CIdvnAh5TmsbchXlQaJlIczLehI/vtvMZv2BJsTl8p/fqDP0tIjFGg7ae9U7aYW4h7jbm+AUQZJA5F1zTz0jzcxoJHdw/etetYOvlf+fprJGcexybb/FS8jjSRrpN12C9Cn/jwJai9MNmo1ae+KDVvdYM1lbGhsAb6xWCStfZcKT4zDPCJC7K7wvJnCC4AwQkEYYPr83wxuP0yujuqr0XBjXxDJp+Wx2mrRzDQ8EiKep9A== X-YMail-OSG: Wc90tYsVM1my1H_KWcccNhlUuG2rmY1aADyNZLP2GabRibxDwVD3Dm4c5STJo4R MCeyu7yZya.B7S7VqH1z7AAPHgLF4X_uMMbvIVTTpu91RIncTZXYUNgR1AWaj6RyJi_4O.CGr8hR BoLbu4A4mutTZHxZ9APSDv5D_RtBT1cIAIrECFPBbo1Ts29qwlJF2uzVED1KmD_JpPKuUrcdUTl5 AACieQmNdQvnlBUognEmWokXkV_1viQiNczmlOSBDIYaVCAajTFpXlRoSLD5PfvGymYijCkox7lH rBxAEWJnV9hRWP1t4O302d5fwb4f.1VqoXmnJSmyfegPWclYBRUtgpAoWRZcr0SHI8AGKu98ldmJ uoQH0oz5e4bPjBNBVrj.nWU4iNC2Xf4DrL.fwayeNcuneYDIu98Tig7Y_yCoiOQE3cWdwNAbviPk z9pqo2s_C5CKMT9Sj65EcsqU2QwyLnwRbxQ5F8B9llfHTSYfln5a6_y_wPdSl9c7RCmM9fd8vhwr BGe6EwZWJN55QNB4dtNvd1PNG2h7tQ2p0yQRtAW6pdROZVerDu73KQIbvWpl6eggrn4649nRkji0 DWlQlQ3QIc1ntYRwi8MYLmff3vA3hj8eWgLmHNKGD34BZdXq5UIVsY4kB4nQsCjSXaalYw4F4XYc 5Re2sCMTJtXBDT3kxqqis2ZLy6PBSedZEn3frmuVYO7TufdF0wVxhS20xI_g8K5gngd65Z3JfbGb nuWUbQ9sePbTP6BKm.yIYu6KjAPcoE4vIELRs8Bd.pHciLvvxBTJ0zWEd0GFYpA.qWLDRwpDMsJ2 t5hSJLvxe_46r8fH5tAa0BmoLFxBD__s5l9Kal4SHw04lnIKcqGnfiY6boSO4d4OSZert5Fiq71q o19UgPOEOPflE3EAvVNtu6y_s9Pnp8ptskuMYm.Bx.4EJbE315ywtSjz3A3DDJ6.EkaXOjI4niA0 vT1WIv3PQOk.vMXRGV86uArjxcqsv7U3otMLLM8BP1X7YD_tlx0b4B7GkweEeh.2Pr5wod6D1iCg 8SnxQRh4nN1K4WjdCr0GwqRPTt9OhXWoE8BjAfnn7NSs4bvO5Wab200lwj_wJ68vNOayTm0SuQPZ Q68wQsMTSEHHqF5Lsmfzy4_RiJSaTK7iZaToNtUfjeOvHFGAiH7YfFvs6NzedcldCQJzvisSUBKy fAecAVNP3kENyHnSK46GXUDhMR7qUr4VKoeRxGp6kMswzUclhmXqjIomIcfGpyCVJIphWGcY31ha VOyS3uH2IP1yihI8VH84rq2Jf9ctWZ6xKBpIbKBJ6ZD2274kJgxsMz68Sb9R185SP8.ZPtnI2Fma m3U50DCbSp_0- Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.bf2.yahoo.com with HTTP; Thu, 10 Oct 2019 14:11:57 +0000 Date: Thu, 10 Oct 2019 14:11:53 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Luca Ferrari Cc: "David G. Johnston" , Pgsql-admin Message-ID: <1943078548.4158063.1570716713369@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> Subject: Re: how to call a stored function on conflict MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4158062_423160799.1570716713368" X-Mailer: WebService/1.1.14448 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: 5038 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_4158062_423160799.1570716713368 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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.=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 Thursday, October 10, 2019, 09:39:45 AM EDT, Luca Ferrari wrote: =20 =20 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_4158062_423160799.1570716713368 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thank you, I finally made it work yesterda= y afternoon.

thank you so much for everything.

v/r,

Bach-Ng= a

No one in this world is pure and= perfect.  If you avoid people for their mistakes you will be alone. S= o judge less, love and forgive more.
To = call him a dog hardly seems to do him justice though in as much as he had f= our legs, a tail, and barked, I admit he was, to all outward appearances. B= ut to those who knew him well, he was a perfect gentleman (Hermione Gingold= )

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


=20
=20
On Thursday, October 10, 2019, 09:39:45 AM EDT, Luca Fe= rrari <fluca1978@gmail.com> wrote:


On Wed, Oct 9, 2019 at 4:26 PM Pepe T= D Vo <pepevo@yahoo.com> wrote:

> would you please tell me wh= at the issue here?


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

Luca

------=_Part_4158062_423160799.1570716713368--