Re: Limit on updates made in a transaction

On Saturday 27 Jul 2002 4:25 am, Kent Tong wrote:
> Hi,
>
> Is there is any limit on the number of updates made to a
> postgreSQL database in a single transaction?

No - although since the machine needs to be able to rollback the updates you
could run out of resources on the machine.

> If yes, how
> can we get around this problem? For example, we need to
> update a field of many existing rows in a table triggered
> by the addition of a new row. If anything fails in the
> update process, we'd like to undone everything (including
> the addition of the new row).

No problem - that's what the system is designed for.

- Richard Huxton