alternative to using a sequence

Поиск
Список
Период
Сортировка
От snacktime
Тема alternative to using a sequence
Дата
Msg-id 1f060c4c0608252138w6a53e640j734eaf6cbfb6c75b@mail.gmail.com
обсуждение исходный текст
Ответы Re: alternative to using a sequence
Re: alternative to using a sequence
Список pgsql-general
I have an application that processes financial transactions.  Each of
these transactions needs to be sent with a sequence number.  It starts
at 1 and resets to 1 once it hits 8000.   I'm trying to think of the
most elegant solution without having to create a sequence for each
user (there are hundreds).  There is a table that holds the
configuration parameters for each merchant, so a field in that table
to hold the sequence number would be ideal.  In the past I've used
sequences as well as just a field which I query then update.  Any
other ideas?

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Errors from pgbench
Следующее
От: Ragnar
Дата:
Сообщение: Re: speeding up big query lookup