On 2010-04-06, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> wrote:
> Content-Type: text/plain; charset=ISO-8859-1
> I have an UPDATE command which modifies several records of one (only one)
> Is it feasible (or a good idea) to include it in a transaction block to make
> sure the process is performed with integrity?
> 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.
In response to
pgsql-novice by date
|Next:||From: Machiel Richards||Date: 2010-04-08 12:52:37|
|Subject: FW: Postgres cpu & memory usage|
|Previous:||From: Jasen Betts||Date: 2010-04-08 09:42:36|
|Subject: Re: Read only postgres server|