Re: Do I need serializable for this query?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: William Garrison <postgres(at)mobydisk(dot)com>
Subject: Re: Do I need serializable for this query?
Date: 2007-04-10 20:52:11
Message-ID: 200704102252.11585.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

William Garrison wrote:
> I have a table that keeps running totals. It is possible that this
> would get called twice simultaneously for the same UserID. Do I need
> to put this in a serializable transaction?

Transaction isolation is only a question of interest if you have more
than one statement in a transaction.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2007-04-10 20:52:38 Re: Versioning
Previous Message Jeff Davis 2007-04-10 20:28:16 Re: Do I need serializable for this query?