safely increase a single column integer value

From: Anton Andreev <fn30762(at)fmi(dot)uni-sofia(dot)bg>
To: pgsql-general(at)postgresql(dot)org
Subject: safely increase a single column integer value
Date: 2007-11-05 23:20:22
Message-ID: 472FA536.9040600@fmi.uni-sofia.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

What is the best way from concurrency point of view to increase a
integer value from a table?

Suppose you count every postback from all the users that are currently
browsing your web-site.

Cheers,
Anton

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Samantha Atkins 2007-11-06 07:12:21 for libpq which include defines the type oids
Previous Message Tom Hart 2007-11-05 22:56:38 Re: php and postgres - too many queries too fast?