Value of serial data type after insert.
| От | Ernest Kim |
|---|---|
| Тема | Value of serial data type after insert. |
| Дата | |
| Msg-id | 20041110193422.GA1531@cs.bu.edu обсуждение исходный текст |
| Ответы |
Re: Value of serial data type after insert.
|
| Список | pgsql-general |
I was wondering if there was a way to get the value of serial data
type after an insert. For example, you have the following table:
create table my_names (
id serial unique,
name varchar(10)
);
And then you do the following:
insert into my_names values ('Ernie');
How do I get the value of the "id" column after the insert command? I
want to make sure that I avoid race conditions, for example:
User A: insert into my_names values ('Ernie');
User B: insert into my_names values ('Bob');
User A: select last_value from my_names_id_seq;
User B: select last_value from my_names_id_seq;
Both user A and B end up with the same returned value after the select
command.
Note this would be coded through PHP if this helps at all. Thanks.
-Ernie
В списке pgsql-general по дате отправления: