Всё продумано:
PostgreSQL docs
currval
Return the value most recently obtained by nextval for this sequence
in the current session . (An error is reported if nextval has never been called for this sequence in this session.) Notice that because this is returning a
session-local value , it gives a predictable answer whether or not other sessions have executed nextval since the current session did.
Так что юзер вася
НЕ может получить id записи которую добавил петя :)
Хотя я обычно через ХП:
1.
2.
3.
4.
5.
6.
create function insert_new_record(_data some_type) returns bigint as $$
BEGIN
insert into data_t (id, data) values (nextval('data_seq'), _data);
return currval('data_seq');
END
$$ language 'plpgsql';
