Getting the next sequence value safely
От
Jeremy Buchmann
Тема
Getting the next sequence value safely
Дата
Msg-id
F2FC22BB-7A5C-11D6-BD7D-000502E740BA@wellsgaming.com
Список
Дерево обсуждения
Getting the next sequence value safely Jeremy Buchmann <jeremy@wellsgaming.com>
Re: Getting the next sequence value safely Dave Cramer <Dave@micro-automation.net>
Hi, I have a situation where I want to insert a record into a table which will give the record a unique id via a sequence. Is there an easy and safe way to get this id number either right before or right after the insertion? My best idea is to select last_value from the sequence and then assume that the record will get last_value + 1 when it is inserted (the insertion would happen right after the select). Is this a safe assumption? What happens if I wrap these operations in a transaction? Is there a standard way of doing this? Thanks, --Jeremy
В списке pgsql-jdbc по дате отправления