SERIAL order and INSERT order
| От | l1@nym.hush.com |
|---|---|
| Тема | SERIAL order and INSERT order |
| Дата | |
| Msg-id | 20110614183036.58B4314DBCF@smtp.hushmail.com обсуждение исходный текст |
| Ответы |
Re: SERIAL order and INSERT order
Re: SERIAL order and INSERT order |
| Список | pgsql-novice |
Hi I have a table defined as follows: CREATE TABLE mytable ( seqnumber BIGSERIAL; ... ) and I have multiple threads inserting into the table. If multiple threads insert at the same time, will the sequence numbers generated always appear in the table in order? e.g. thread 1 does INSERT getting serial number 1 thread 2 does INSERT getting serial number 2 and both complete successfully (no rollbacks). Are there any cases where an observer might see a row with serial number 2 but not yet see serial number 1, perhaps because thread 1 hasn't completed its insert yet? For example SELECT * WHERE seqnumber < 3; would return only a row with seqnumber=2? thanks
В списке pgsql-novice по дате отправления: