Re: Information on savepoint requirement within transctions

From: Adam Tauno Williams <awilliam(at)whitemice(dot)org>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Information on savepoint requirement within transctions
Date: 2018-01-29 11:37:37
Message-ID: 1517225857.3055.1.camel@whitemice.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>  * Why are they required in combination with failing statements (when
> every other database does an "automatic savepoint and rollback" for a
> failed statement)?

It this statement true?  I very much feel *not*.  This depends on how
you have set AUTO_COMMIT - and it certainly is not true for
transactions of multiple statements.

Informix does not do "automatic savepoint and rollback" - you will
rollback the entire transaction.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Zenz 2018-01-29 11:49:54 Fwd: Re: Information on savepoint requirement within transctions
Previous Message Robert Zenz 2018-01-29 08:37:22 Re: Information on savepoint requirement within transctions