Re: TRANSACTION FOR AN UPDATE COMMAND WITH ONE TABLE

On 2010-04-06, JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
> --001485e609d13a8c510483958cf7
> Content-Type: text/plain; charset=ISO-8859-1
>
> I have an UPDATE command which modifies several records of one (only one)
> table.
> Is it feasible (or a good idea) to include it in a transaction block to make
> sure the process is performed with integrity?
> Or
> Does PostgreSQL has some kind of auto-integrity check with simple DB
> operations like?

a single update command either succeeds or fails.
if it fails no records will have changed, if it succeds all the
matching records will have been updated.

wrapping it in a transaction will gain you nothing.