Postgres Pro
Downloads
Home   >   mailing lists

Re: Do I need serializable for this query? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Do I need serializable for this query?
Date
Msg-id 200704102252.11585.peter_e@gmx.net
Whole thread Raw
In response to Do I need serializable for this query?  (William Garrison <postgres@mobydisk.com>)
Responses Re: Do I need serializable for this query?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Do I need serializable for this query?
Next
From: Jonathan Vanasco
Date:
Subject: Re: Versioning