Re: [GENERAL] Multiple Sequence Number for One Column p.2

2016-02-02 Thread David G. Johnston
On Tue, Feb 2, 2016 at 4:28 AM, alexander wrote: > Hello > > I've met exactly the same problem as described here > http://www.postgresql.org/message-id/95862fdc-eb2e-4533-8331-d49775b0e...@f2g2000yqf.googlegroups.com > . For now, I use the same solution that was presented in the response > http:/

Re: [GENERAL] multiple sequence number for one column

2011-05-05 Thread David Johnston
> > Is there a good way to solve this issue? > > Thanks a lot > Yes, multiple actually. ... one db centric solution is to create a sequence for each customer id and then nextval that specific sequence when you need a new id. Would need to know more about the number of customers and how

Re: [GENERAL] multiple sequence number for one column

2011-05-05 Thread Merlin Moncure
On Thu, May 5, 2011 at 1:54 PM, mirthcyy wrote: > hi group, > > we need help on one postgresql locking issue: > > Originally we have a table like below; > > id bigint not null nextval('xxx)', > customer_id int not null, > insert_record_date timestamp not null > ... > > so this id column is using a