Re: how to call a stored function on conflict
Pepe TD Vo <[email protected]> Fri, 11 Oct 2019 16:52:50 +0000 (UTC)
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <[email protected]> |
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 . <[email protected]> wrote:
Hi,
How did you resolve it. Kindly share.
Thanks
Deepak
Get Outlook for Android
From: Pepe TD Vo <[email protected]>
Sent: Thursday, October 10, 2019 7:41:53 PM
To: Luca Ferrari <[email protected]>
Cc: David G. Johnston <[email protected]>; Pgsql-admin <[email protected]>
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 <[email protected]> wrote:
On Wed, Oct 9, 2019 at 4:26 PM Pepe TD Vo <[email protected]> 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