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)
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)