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:/

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

2016-02-02 Thread alexander
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://www.postgresql.org/message-id/077da5f9-f783-4388-bf19-42e

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

[GENERAL] multiple sequence number for one column

2011-05-05 Thread mirthcyy
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 sequence number that applies to all customers. And it's the primary