Sequences
От | Anand Surelia |
---|---|
Тема | Sequences |
Дата | |
Msg-id | 362D1977.850A84B5@bytekinc.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] Sequences
|
Список | pgsql-general |
Hi All, I am using a sequence to automatically generate a transaction number in my database. I've set up the transaction number to have a default value from the sequence, so that I don't have to provide a number while entering. However, I want to know the number of the transaction I've just entered. I can do that by calling curval(sequence), but in a dynamic situation with lot of transactions being recorded by multiple users, how can I be sure I am getting the value which I had entered. It sounds silly, but I am sure there is a simple solution for it. Do I have to lock the sequence while I am using so that no one else can use it, or do I fire both the queries in the same TRANSACTION block? Thanks for any help, Anand.
В списке pgsql-general по дате отправления: