pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how to call a stored function on conflict
8+ messages / 5 participants
[nested] [flat]

* how to call a stored function on conflict
@ 2019-10-08 18:56 Pepe TD Vo <pepevo@yahoo.com>
  2019-10-08 19:29 ` Re: how to call a stored function on conflict Holger Jakobs <holger@jakobs.com>
  2019-10-08 19:29 ` Re: how to call a stored function on conflict David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 2 replies; 8+ messages in thread

From: Pepe TD Vo @ 2019-10-08 18:56 UTC (permalink / raw)
  To: pgsql-admin

Hello experts,
I have a store function on conflict to update and insert features information from one table to another table  
My code is:
create or replace FUNCTION ecisdrdm.pr_mig_stg_application_cdim (v_Ret OUT bigint ) as $$declare         v_ErrorCode             bigint;        v_ErrorMsg              varchar(512);        v_Module                varchar(32) = 'pr_mig_stg_application_cdim';
begin
------ MERGING: STG_APPLICATION_CDIM into APPLICATION_CDIM----
INSERT INTO application_cdim AS prod (prod.application_id, prod.receipt_number,prod.init_frm_id, prod.frm_typ_id,   prod.sbmtd_dt_id, prod.crtd_user_id, prod.init_src_sys_id, prod.init_svc_ctr_id, prod.mig_filename) SELECT stg.application_id, stg.receipt_number, stg.init_frm_id, stg.frm_typ_id, stg.sbmtd_dt_id, stg.crtd_user_id, stg.init_src_sys_id, stg.init_svc_ctr_id, stg.mig_filename FROM ecisdrdm.stg_application stgON CONFLICT (application_id)  DO UPDATE SET ( prod.init_frm_id, prod.frm_typ_id,prod. sbmtd_dt_id, prod.crtd_user_id,  prod.init_src_sys_id, prod.init_svc_ctr_id, prod.mig_filename, prod.mig_modified_dt)= (SELECT stg.init_frm_id, stg.frm_typ_id, stg.sbmtd_dt_id, stg.crtd_user_id,  stg.init_src_sys_id, stg.init_svc_ctr_id, stg.mig_filename, current_timestampFROM ecisdrdm.stg_application_cdim stgWHERE prod.receipt_number = stg.receipt_number);           RETURN;
   ----   -- Set the return code to 0   ----
   v_Ret := SQLSTATE;
------ Exception error handler----exception   when others then v_ErrorCode := SQLSTATE; v_ErrorMsg  := SQLERRM; v_Ret       := v_ErrorCode;
 ---- -- Commit the record into the ErrorLog ---- PERFORM pr_write_error_log( v_os_user, v_host, v_module, v_ErrorCode, v_ErrorMsg );
 ---- -- Intentionally leaving the "commit" to application ----end;$$ language plpgsql;
and my other function for pr_write_error_log is 
CREATE OR REPLACE FUNCTION ecisdrdm.pr_write_error_log ( v_os_user character varying, v_host character varying, v_module character varying, v_errorcode integer, v_errormsg character varying)    RETURNS void    LANGUAGE 'plpgsql'
    COST 100    VOLATILE AS $BODY$
BEGIN START TRANSACTION; INSERT INTO ecisdrdm.errorlog(tstamp, os_user, host, module, errorcode, errormsg) VALUES    (CURRENT_TIMESTAMP, CURRENT_USER, inet_server_addr(), v_module, v_ErrorCode, v_ErrorMsg );
        /* commit; */ end;
$BODY$;
ALTER FUNCTION ecisdrdm.pr_write_error_log (character varying, character varying, character varying, integer, character varying)    OWNER TO "PSmasteruser";

they all created successfully.
when I execute the function of pr_mig_stg_application_cdim as "select ecisdrdm.pr_mig_stg_application_cdim(); "
ERROR: invalid input syntax for integer: "42P01"CONTEXT: PL/pgSQL function ecisdrdm.pr_mig_stg_application_cdim() line 41 at assignmentSQL state: 22P02
may I know how to execute the stored function?  What did wrong on my queries?
thank you for your help.
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

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: how to call a stored function on conflict
  2019-10-08 18:56 how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
@ 2019-10-08 19:29 ` Holger Jakobs <holger@jakobs.com>
  1 sibling, 0 replies; 8+ messages in thread

From: Holger Jakobs @ 2019-10-08 19:29 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

Hi Pepe,

the SQLSTATE is not an integer or bigint, so it cannot be stored in a
variable declared as bigint.

See https://www.postgresql.org/docs/current/errcodes-appendix.html

Regards,

Holger

Am 08.10.19 um 20:56 schrieb Pepe TD Vo:
> Hello experts,
>
> I have a store function on conflict to update and insert features
> information from one table to another table  
>
> My code is:
>
> create or replace FUNCTION ecisdrdm.pr_mig_stg_application_cdim (v_Ret
> OUT bigint ) 
> as $$
> declare 
>         v_ErrorCode             bigint;
>         v_ErrorMsg              varchar(512);
>         v_Module                varchar(32) =
> 'pr_mig_stg_application_cdim';
>
> begin
>
> ----
> -- MERGING: STG_APPLICATION_CDIM into APPLICATION_CDIM
> ----
>
> INSERT INTO application_cdim AS prod (prod.application_id,
> prod.receipt_number,prod.init_frm_id, prod.frm_typ_id,  
> prod.sbmtd_dt_id, prod.crtd_user_id, prod.init_src_sys_id,
> prod.init_svc_ctr_id, prod.mig_filename) 
> SELECT stg.application_id, stg.receipt_number, stg.init_frm_id,
> stg.frm_typ_id, stg.sbmtd_dt_id, stg.crtd_user_id,
> stg.init_src_sys_id, stg.init_svc_ctr_id, stg.mig_filename 
> FROM ecisdrdm.stg_application stg
> ON CONFLICT (application_id)  DO UPDATE 
> SET ( prod.init_frm_id, prod.frm_typ_id,prod. sbmtd_dt_id,
> prod.crtd_user_id, 
> prod.init_src_sys_id, prod.init_svc_ctr_id, prod.mig_filename,
> prod.mig_modified_dt
> )
> = 
> (SELECT stg.init_frm_id, stg.frm_typ_id, stg.sbmtd_dt_id,
> stg.crtd_user_id,
>  stg.init_src_sys_id, stg.init_svc_ctr_id, stg.mig_filename,
> current_timestamp
> FROM ecisdrdm.stg_application_cdim stg
> WHERE prod.receipt_number = stg.receipt_number
> );           
> RETURN;
>
>    ----
>    -- Set the return code to 0
>    ----
>
>    v_Ret := SQLSTATE;
>
> ----
> -- Exception error handler
> ----
> exception
>    when others then
> v_ErrorCode := SQLSTATE;
> v_ErrorMsg  := SQLERRM;
> v_Ret       := v_ErrorCode;
>
> ----
> -- Commit the record into the ErrorLog
> ----
> PERFORM pr_write_error_log( v_os_user, v_host, v_module, v_ErrorCode,
> v_ErrorMsg );
>
> ----
> -- Intentionally leaving the "commit" to application
> ----
> end;
> $$ language plpgsql;
>
> and my other function for pr_write_error_log is 
>
> CREATE OR REPLACE FUNCTION ecisdrdm.pr_write_error_log (
> v_os_user character varying,
> v_host character varying,
> v_module character varying,
> v_errorcode integer,
> v_errormsg character varying)
>     RETURNS void
>     LANGUAGE 'plpgsql'
>
>     COST 100
>     VOLATILE 
> AS $BODY$
>
> BEGIN
> START TRANSACTION;
> INSERT INTO ecisdrdm.errorlog(tstamp, os_user, host, module,
> errorcode, errormsg)
> VALUES
>    (CURRENT_TIMESTAMP, CURRENT_USER, inet_server_addr(), v_module,
> v_ErrorCode, v_ErrorMsg );
>
>         /* commit; */
> end;
>
> $BODY$;
>
> ALTER FUNCTION ecisdrdm.pr_write_error_log (character varying,
> character varying, character varying, integer, character varying)
>     OWNER TO "PSmasteruser";
>
>
> they all created successfully.
>
> when I execute the function of pr_mig_stg_application_cdim as "select
> ecisdrdm.pr_mig_stg_application_cdim(); "
>
> ERROR: invalid input syntax for integer: "42P01" CONTEXT: PL/pgSQL
> function ecisdrdm.pr_mig_stg_application_cdim() line 41 at assignment
> SQL state: 22P02
>
> may I know how to execute the stored function?  What did wrong on my
> queries?
>
> thank you for your help.
>
> **
> *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
-- 

Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@jakobs.com
+49 178 9759012 <tel:+491789759012> oder +49 2202 817157
<tel:+492202817157>

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: how to call a stored function on conflict
  2019-10-08 18:56 how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
@ 2019-10-08 19:29 ` David G. Johnston <david.g.johnston@gmail.com>
  2019-10-09 14:26   ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  1 sibling, 1 reply; 8+ messages in thread

From: David G. Johnston @ 2019-10-08 19:29 UTC (permalink / raw)
  To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: pgsql-admin

On Tue, Oct 8, 2019 at 11:56 AM Pepe TD Vo <pepevo@yahoo.com> wrote:

> ERROR: invalid input syntax for integer: "42P01" CONTEXT: PL/pgSQL
> function ecisdrdm.pr_mig_stg_application_cdim() line 41 at assignment SQL
> state: 22P02
>

You made an assumption that the error code was an integer.  As the error
message is pointing out one possible value of the error code is "42P01"
which is not an integer.  You need to fix your code to match reality - that
the error code is an alphanumic.

may I know how to execute the stored function?
>

The fact that the function provoked an error means that it was executed.....

David J.

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: how to call a stored function on conflict
  2019-10-08 18:56 how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-08 19:29 ` Re: how to call a stored function on conflict David G. Johnston <david.g.johnston@gmail.com>
@ 2019-10-09 14:26   ` Pepe TD Vo <pepevo@yahoo.com>
  2019-10-10 13:39     ` Re: how to call a stored function on conflict Luca Ferrari <fluca1978@gmail.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Pepe TD Vo @ 2019-10-09 14:26 UTC (permalink / raw)
  To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-admin

thank you for your input.
even I create v_Ret as character varying and it still complained the same error.
create or replace FUNCTION ecisdrdm.pr_mig_stg_application_cdim (v_Ret OUT character varying )
ERROR: invalid input syntax for integer: "42P01" CONTEXT: PL/pgSQL function ecisdrdm.pr_mig_stg_application_cdim() line 39 at assignment SQL state: 22P02
I worked around and create errorlog table with errorcode declare as varchar(20) and recreate a function pr_write_error_log (v_ret text).  Again the function combined and select function (pr_write_error_log) fine 



But the function to merge(update)/insert on conflict is still not work even when I run the select function  (pr_mig_stg_application_cdim), not sure this is corrected answer?  It's one row affected.


but two tables are not update/insert any data from one to another.

stg_application_cdim:


application_cdim:


my "on conflict" is:
INSERT INTO ecisdrdm.application_cdim AS prod (prod.application_id, prod.receipt_number,prod.init_frm_id, prod.frm_typ_id,      prod.sbmtd_dt_id, prod.crtd_user_id, prod.init_src_sys_id, prod.init_svc_ctr_id, prod.mig_filename)  SELECT stg.application_id, stg.receipt_number, stg.init_frm_id, stg.frm_typ_id, stg.sbmtd_dt_id, stg.crtd_user_id,   stg.init_src_sys_id, stg.init_svc_ctr_id, stg.mig_filename  FROM ecisdrdm.stg_application stg ON CONFLICT (application_id)  DO UPDATE  SET ( prod.init_frm_id, prod.frm_typ_id,prod. sbmtd_dt_id, prod.crtd_user_id,     prod.init_src_sys_id, prod.init_svc_ctr_id, prod.mig_filename, prod.mig_modified_dt )=  (SELECT stg.init_frm_id, stg.frm_typ_id, stg.sbmtd_dt_id, stg.crtd_user_id,      stg.init_src_sys_id, stg.init_svc_ctr_id, stg.mig_filename, current_timestamp FROM ecisdrdm.stg_application_cdim stg WHERE prod.receipt_number = stg.receipt_number );
would you please tell me what the issue here?
thank you so much.
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 Tuesday, October 8, 2019, 03:29:59 PM EDT, David G. Johnston <david.g.johnston@gmail.com> wrote:  
 
 On Tue, Oct 8, 2019 at 11:56 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
ERROR: invalid input syntax for integer: "42P01"CONTEXT: PL/pgSQL function ecisdrdm.pr_mig_stg_application_cdim() line 41 at assignmentSQL state: 22P02

You made an assumption that the error code was an integer.  As the error message is pointing out one possible value of the error code is "42P01" which is not an integer.  You need to fix your code to match reality - that the error code is an alphanumic.

may I know how to execute the stored function?

The fact that the function provoked an error means that it was executed.....
David J.
  

Attachments:

1570630244436blob.jpg (image/png, 11.8K) download view image
1570630785668blob.jpg (image/png, 10.5K) download view image
1570630921766blob.jpg (image/png, 101.3K) download view image
1570631002967blob.jpg (image/png, 61.0K) download view image
1570631073959blob.jpg (image/png, 7.4K) download view image
^ permalink raw reply [nested|flat] 8+ messages in thread

* Re: how to call a stored function on conflict
  2019-10-08 18:56 how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-08 19:29 ` Re: how to call a stored function on conflict David G. Johnston <david.g.johnston@gmail.com>
  2019-10-09 14:26   ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
@ 2019-10-10 13:39     ` Luca Ferrari <fluca1978@gmail.com>
  2019-10-10 14:11       ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Luca Ferrari @ 2019-10-10 13:39 UTC (permalink / raw)
  To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: how to call a stored function on conflict
  2019-10-08 18:56 how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-08 19:29 ` Re: how to call a stored function on conflict David G. Johnston <david.g.johnston@gmail.com>
  2019-10-09 14:26   ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-10 13:39     ` Re: how to call a stored function on conflict Luca Ferrari <fluca1978@gmail.com>
@ 2019-10-10 14:11       ` Pepe TD Vo <pepevo@yahoo.com>
  2019-10-11 04:27         ` Re: how to call a stored function on conflict Deepak Pahuja . <deepakpahuja@hotmail.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Pepe TD Vo @ 2019-10-10 14:11 UTC (permalink / raw)
  To: Luca Ferrari <fluca1978@gmail.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-admin

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
  

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: how to call a stored function on conflict
  2019-10-08 18:56 how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-08 19:29 ` Re: how to call a stored function on conflict David G. Johnston <david.g.johnston@gmail.com>
  2019-10-09 14:26   ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-10 13:39     ` Re: how to call a stored function on conflict Luca Ferrari <fluca1978@gmail.com>
  2019-10-10 14:11       ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
@ 2019-10-11 04:27         ` Deepak Pahuja . <deepakpahuja@hotmail.com>
  2019-10-11 16:52           ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Deepak Pahuja . @ 2019-10-11 04:27 UTC (permalink / raw)
  To: Pepe TD Vo <pepevo@yahoo.com>; Luca Ferrari <fluca1978@gmail.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-admin

Hi,
How did you resolve it. Kindly share.

Thanks
Deepak

Get Outlook for Android<https://aka.ms/ghei36;

________________________________
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<mailto: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

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: how to call a stored function on conflict
  2019-10-08 18:56 how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-08 19:29 ` Re: how to call a stored function on conflict David G. Johnston <david.g.johnston@gmail.com>
  2019-10-09 14:26   ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-10 13:39     ` Re: how to call a stored function on conflict Luca Ferrari <fluca1978@gmail.com>
  2019-10-10 14:11       ` Re: how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
  2019-10-11 04:27         ` Re: how to call a stored function on conflict Deepak Pahuja . <deepakpahuja@hotmail.com>
@ 2019-10-11 16:52           ` Pepe TD Vo <pepevo@yahoo.com>
  0 siblings, 0 replies; 8+ messages in thread

From: Pepe TD Vo @ 2019-10-11 16:52 UTC (permalink / raw)
  To: Luca Ferrari <fluca1978@gmail.com>; Deepak Pahuja . <deepakpahuja@hotmail.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; 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

Get Outlook for Android
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
  

^ permalink  raw  reply  [nested|flat] 8+ messages in thread


end of thread, other threads:[~2019-10-11 16:52 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-10-08 18:56 how to call a stored function on conflict Pepe TD Vo <pepevo@yahoo.com>
2019-10-08 19:29 ` Holger Jakobs <holger@jakobs.com>
2019-10-08 19:29 ` David G. Johnston <david.g.johnston@gmail.com>
2019-10-09 14:26   ` Pepe TD Vo <pepevo@yahoo.com>
2019-10-10 13:39     ` Luca Ferrari <fluca1978@gmail.com>
2019-10-10 14:11       ` Pepe TD Vo <pepevo@yahoo.com>
2019-10-11 04:27         ` Deepak Pahuja . <deepakpahuja@hotmail.com>
2019-10-11 16:52           ` Pepe TD Vo <pepevo@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox