Oh yeah, I must add new begin ... exception .. end; block between.
So like this:
BEGIN
BEGIN
EXCEPTION when ..... then ..
END;
END;
At first I did like this:
BEGIN
.....
EXCEPTION when ..... then ..;
END;
Raul
Kontakt hubert depesz lubaczewski (<depesz@xxxxxxxxxx>) kirjutas kuupäeval K, 5. veebruar 2020 kell 17:03:
On Wed, Feb 05, 2020 at 04:17:09PM +0200, Raul Kaubi wrote:
> Let's say I want my procedure/function to resume work after specific error
> ( duplicate_table ).
> Is it possible to resume work after error..?
> EXCEPTION
> > WHEN duplicate_table then ......;
Sure you can:
https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
Best regards,
depesz
