Re: [ADMIN] incrementing updates and locks

2010-09-16 Thread Kevin Grittner
Craig James wrote: > given what you have told us about your application, it is probably > not very important if a few ORDER ID numbers are missing. I'm not so sure. If these are considered accounting records which may be audited by a CPA firm, I would definitely check with the accountants bef

Re: [ADMIN] incrementing updates and locks

2010-09-16 Thread Craig James
On 9/16/10 4:17 PM, Aras Angelo wrote: Daniel, Craig The gaps are not really expected. It is set once only. Its about printing packing slips for ecommerce orders. We have the ORDER ID sequence, but so many different stations are accessing these orders, if my station print the next 100 orders f

Re: [ADMIN] incrementing updates and locks

2010-09-16 Thread Aras Angelo
Dumb i am.. nextval() already issued the next one to the sequence. I probably dont need a separate table. On Thu, Sep 16, 2010 at 4:17 PM, Aras Angelo wrote: > Daniel, Craig > > The gaps are not really expected. It is set once only. > Its about printing packing slips for ecommerce orders. We hav

Re: [ADMIN] incrementing updates and locks

2010-09-16 Thread Aras Angelo
Daniel, Craig The gaps are not really expected. It is set once only. Its about printing packing slips for ecommerce orders. We have the ORDER ID sequence, but so many different stations are accessing these orders, if my station print the next 100 orders from the que, id like to give them values st

Re: [ADMIN] incrementing updates and locks

2010-09-16 Thread Craig James
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,

Re: [ADMIN] incrementing updates and locks

2010-09-16 Thread Daniel J. Summers
On 09/16/2010 10:54 PM, Aras Angelo wrote: Hello All I have a column in my table which is incrementally updated. I cant set this field to be a SERIAL because the value is not assigned at the time of the INSERT, it is assigned later by the system by an UPDATE. Whats the best way to achieve thi

[ADMIN] incrementing updates and locks

2010-09-16 Thread Aras Angelo
Hello All I have a column in my table which is incrementally updated. I cant set this field to be a SERIAL because the value is not assigned at the time of the INSERT, it is assigned later by the system by an UPDATE. Whats the best way to achieve this by means of performance? Should i set the MAX