Re: rollback previous commit if the current one fails

2021-04-13 Thread pinker
thank you Luis, but this is not supported in plpgsql -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: rollback previous commit if the current one fails

2021-04-13 Thread luis . roberto
- Mensagem original - > Any idea how to approach it? Hi! https://www.postgresql.org/docs/current/sql-savepoint.html Luis R. Weck

rollback previous commit if the current one fails

2021-04-13 Thread pinker
Hi, i need to emulate oracle's savepoint behaviour inside of the plpgsql function. This function is able to insert all the rows that weren't caught on the exception, but i need also to rollback the insert that happens before the exception. So let's say the exception is thrown when j=3 so i need a