On 1/16/24 00:06, Dominique Devienne wrote:
> On Mon, Jan 15, 2024 at 5:17 AM veem v <veema0000@gmail.com
> <mailto:veema0000@gmail.com>> wrote:
>
> Is any key design/architectural changes should the app development
> team [...], should really aware about
>
>
> Hi. One of the biggest pitfall of PostgreSQL, from the app-dev perspective,
> is the fact any failed statement fails the whole transaction, with
> ROLLBACK as the only recourse.
https://www.postgresql.org/docs/current/sql-savepoint.html
"SAVEPOINT establishes a new savepoint within the current transaction.
A savepoint is a special mark inside a transaction that allows all
commands that are executed after it was established to be rolled back,
restoring the transaction state to what it was at the time of the
savepoint."
--
Adrian Klaver
adrian.klaver@aklaver.com