Re: Error handling: Resume work after error

2020-02-05 Thread Raul Kaubi
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 () kirjutas kuupƤeval K, 5. v

Re: Error handling: Resume work after error

2020-02-05 Thread hubert depesz lubaczewski
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

Error handling: Resume work after error

2020-02-05 Thread Raul Kaubi
Hi PostgreSQL 12.1 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 ..; Or is there different approach to achieve that..? Thanks Raul