Error handling: Resume work after error

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

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@depesz.com>) kirjutas kuupäeval
K, 5. veebruar 2020 kell 17:03: