Re: how to call a stored function on conflict - Mailing list pgsql-admin

From Pepe TD Vo
Subject Re: how to call a stored function on conflict
Date
Msg-id 396922018.196756.1570812770794@mail.yahoo.com
Whole thread Raw
In response to Re: how to call a stored function on conflict  ("Deepak Pahuja ." <deepakpahuja@hotmail.com>)
List pgsql-admin
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


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

pgsql-admin by date:

Previous
From: Albert Shih
Date:
Subject: Strange behavior over WAN
Next
From: Fernando Hevia
Date:
Subject: Re: Strange behavior over WAN