Home > mailing lists

TRANSACTION FOR AN UPDATE COMMAND WITH ONE TABLE - Mailing list pgsql-novice

From	JORGE MALDONADO
Subject	TRANSACTION FOR AN UPDATE COMMAND WITH ONE TABLE
Date	April 6, 2010 15:50:33
Msg-id	k2of03943a01004061123o223f4ec9mc385ff0207931e85@mail.gmail.com Whole thread Raw
Responses	Re: TRANSACTION FOR AN UPDATE COMMAND WITH ONE TABLE Re: TRANSACTION FOR AN UPDATE COMMAND WITH ONE TABLE
List	pgsql-novice

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?

Does PostgreSQL has some kind of auto-integrity check with simple DB operations like?

Best regards,

Jorge Maldonado

From: Matt Devlin
Date: 06 April 2010, 14:33:11
Subject: postgres install question

From: "Rob Richardson"
Date: 06 April 2010, 16:02:44
Subject: Re: TRANSACTION FOR AN UPDATE COMMAND WITH ONE TABLE