From: Pepe TD Vo <pepevo@yahoo.com>
To: Luca Ferrari <fluca1978@gmail.com>
To: Deepak Pahuja . <deepakpahuja@hotmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: Pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: how to call a stored function on conflict
Date: Fri, 11 Oct 2019 16:52:50 +0000 (UTC)
Message-ID: <396922018.196756.1570812770794@mail.yahoo.com> (raw)
In-Reply-To: <CH2PR10MB40374C10E9365DA42C063E29D6970@CH2PR10MB4037.namprd10.prod.outlook.com>
References: <1496660547.3525362.1570560989743.ref@mail.yahoo.com>
<1496660547.3525362.1570560989743@mail.yahoo.com>
<CAKFQuwZdNYvFnYgwSNx=9sHogpiBdEOE0AyLLzyX38oz6HpsMA@mail.gmail.com>
<1899900811.3794492.1570631172044@mail.yahoo.com>
<CAKoxK+6uhk+EgqhQnsUR0eDazcsMnKCEx3OzwkJ1Y6DeD15HVw@mail.gmail.com>
<1943078548.4158063.1570716713369@mail.yahoo.com>
<CH2PR10MB40374C10E9365DA42C063E29D6970@CH2PR10MB4037.namprd10.prod.outlook.com>
And someone from Europe advised me work around 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 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 to 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 Friday, October 11, 2019, 12:27:05 AM EDT, Deepak Pahuja . <deepakpahuja@hotmail.com> wrote:
Hi,
How did you resolve it. Kindly share.
Thanks
Deepak
Get Outlook for Android
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-admin <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 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 to 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 <fluca1978@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, fluca1978@gmail.com, deepakpahuja@hotmail.com, david.g.johnston@gmail.com
Subject: Re: how to call a stored function on conflict
In-Reply-To: <396922018.196756.1570812770794@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox