From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
---|---|
To: | Pepe TD Vo <pepevo(at)yahoo(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: can't call function to delete the table |
Date: | 2019-10-16 07:27:50 |
Message-ID: | CAKoxK+6-XO8pDGGWv7RpurTdU=EmB8rskeY2Od2BvKL2GRaPRQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Oct 14, 2019 at 6:27 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
> SELECT pr_mig_bnft_hist_actn_ldim();
>
> execute the store funtion no error but two tables are the same and didn't delete and/or insert any from one to other;
>
As others have already pointed out, you seems to return a trigger
tuple from a normal function, so first step is to remove the "RETURN
NEW". Then I would add a couple of RAISE statements because it sounds
me strange that the function is invoked without producing any error
nor results.
Last, I would change the DELETE with a TRUNCATE, assuming you are not
inserting the very same quantity of rows on the next step.
Luca
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Martin | 2019-10-16 11:30:51 | Save Session? |
Previous Message | Luca Ferrari | 2019-10-16 07:19:30 | Re: Question about pgaudit and the logfile |