Re: Nextval & Currval

Поиск
Список
Период
Сортировка
От Shavonne Marietta Wijesinghe
Тема Re: Nextval & Currval
Дата
Msg-id 00fa01c8cafb$eb8c4660$0602a8c0@DREAM
обсуждение исходный текст
Ответ на Nextval & Currval  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
Ответы Re: Nextval & Currval
Список pgsql-sql
Дерево обсуждения
I managed to make the connection work. I tried inserting records from 2 computers. It works fine untill 2 computers insert a nextwall one after another. 
 
Here is a small example of what i see in my DB
 
++++++|+++++++++++++++++|++++++++++
    N °    |       Session                |   Number
++++++|+++++++++++++++++ |++++++++++
  1        |       DB last record       |   269
  2        |       PC A (nextval )      |   270
  3        |       PC A (nextval )      |   271
  4        |       PC A (currval )       |   271
  5        |       PC A (nextval )      |   272
  6        |       PC A (nextval )      |   273
  7        |       PC B (nextval )      |   274
  8        |       PC A (currval )       |   274
  9        |       PC B (nextval )      |   275
  10      |       PC A (nextval )       |   276
 
Isn't currval connected to its session?? I expected line N° 8  (PC A) to have the Number of the record it inserted a while ago (line N° 273).
 
 
Thank you.
 
Shavonne Wijesinghe

В списке pgsql-sql по дате отправления: