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?
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
