Re: Problem with Sequences

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with Sequences
Дата
Msg-id 10731.1063376176@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with Sequences  (Markus Espenhain <espenhain@etes.de>)
Список pgsql-admin
Markus Espenhain <espenhain@etes.de> writes:
> On user who works with the Database create an new record and save this.
> Here the record becomes an ID and another Number from an two sequences.

> One other user ist in this moment working with the database and create an new record, too.
> Now he becomes in some circumstances the same ID like the first saved record from the other user with the effect,
thatthe other record is nolong in the database. 

> Is this problem possible?

Not unless you're failing to use the sequences correctly.  Show us the
SQL queries being issued by each application, please.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg 7.3.4 and linux box crash
Следующее
От: Jason Alan Smith
Дата:
Сообщение: ...