Re: incrementing updates and locks - Mailing list pgsql-admin

From Craig James
Subject Re: incrementing updates and locks
Date
Msg-id 4C92A2F8.2050209@emolecules.com
Whole thread Raw
In response to incrementing updates and locks  (Aras Angelo <araskoktas@gmail.com>)
Responses Re: incrementing updates and locks  (Aras Angelo <araskoktas@gmail.com>)
List 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
okto 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

pgsql-admin by date:

Previous
From: "Daniel J. Summers"
Date:
Subject: Re: incrementing updates and locks
Next
From: Aras Angelo
Date:
Subject: Re: incrementing updates and locks