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.
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@xxxxxxxxxxx> wrote:
Hi,
How did you resolve it. Kindly share.
Thanks
Deepak
From: Pepe TD Vo <pepevo@xxxxxxxxx>
Sent: Thursday, October 10, 2019 7:41:53 PM
To: Luca Ferrari <fluca1978@xxxxxxxxx>
Cc: David G. Johnston <david.g.johnston@xxxxxxxxx>; Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Re: how to call a stored function on conflict
Sent: Thursday, October 10, 2019 7:41:53 PM
To: Luca Ferrari <fluca1978@xxxxxxxxx>
Cc: David G. Johnston <david.g.johnston@xxxxxxxxx>; Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
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.
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@xxxxxxxxx> wrote:
On Wed, Oct 9, 2019 at 4:26 PM Pepe TD Vo <pepevo@xxxxxxxxx> 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
> 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
