Re: how to call a stored function on conflict

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(at)hotmail(dot)com> wrote:

Hi,
How did you resolve it. Kindly share.

Thanks
Deepak

Get Outlook for Android
From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Sent: Thursday, October 10, 2019 7:41:53 PM
To: Luca Ferrari <fluca1978(at)gmail(dot)com>
Cc: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>; Pgsql-admin <pgsql-admin(at)postgresql(dot)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(at)gmail(dot)com> wrote:

On Wed, Oct 9, 2019 at 4:26 PM Pepe TD Vo <pepevo(at)yahoo(dot)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