Re: incrementing updates and locks

From: Craig James <craig_james(at)emolecules(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: incrementing updates and locks
Date: 2010-09-16 23:06:32
Message-ID: 4C92A2F8.2050209@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 9/16/10 3:54 PM, Aras Angelo wrote:
> Hello All
>
> I have a column in my table which is incrementally updated.

Try to give us more details...

Does the column need have contiguous values or are "gaps" ok? That is, does it have to be 1,2,3,4,...,N-1,N or is it ok to have something like 1,3,4,7,...,M (where M>N) for N rows?

Is the value updated every time the row is changed, or is it set once only?

If gaps are OK, then a sequence is a simple answer.

Craig

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel J. Summers 2010-09-16 23:09:00 Re: incrementing updates and locks
Previous Message Aras Angelo 2010-09-16 22:54:47 incrementing updates and locks