Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?

Поиск
Список
Период
Сортировка
От electrotype
Тема Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?
Дата
Msg-id abb4c189-57f5-9d35-13ac-64976349b41b@gmail.com
обсуждение исходный текст
Ответ на Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
My take is that there is presently no guarantee, and that with current efforts to add parallelism it is quite probable that observation of such non-orderedness is simply a matter of time.  With batching it seems best to combine its use with single inserts in order to avoid this problem.

David J.

I wish that was not the conclusion, but at least it is clear!

Thanks for the help to both of you.

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

Предыдущее
От: Atul Kumar
Дата:
Сообщение: Re: "Required checkpoints occurs too frequently"
Следующее
От: Chris Stephens
Дата:
Сообщение: SQL group by help