deadlock using sequences?

Поиск
Список
Период
Сортировка
От lars hofhansl
Тема deadlock using sequences?
Дата
Msg-id 20021005005317.94539.qmail@web40601.mail.yahoo.com
обсуждение исходный текст
Список pgadmin-support
Hi,

I get occasional deadlocks when using sequences from
multiple clients.

Here's the table DDL:

create sequence ids;
create table foo( id integer default nextval('ids'),
parent integer, type char(4), name text, value text )
without oids;
create index xml_id on xml(id);

I'm inserting 1000s of tuples from 4-5 different
clients (all use JDBC but are single threaded).
About once every 1000 tuples I get

ERROR:  deadlock detected

I can't use OIDS because I have to guarantee
monotonically increasing ids.

Any ideas? Shouldn't sequences be implemented deadlock
free?

Thanks.

-- Lars


__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

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

Предыдущее
От: "Nikolaus Dilger"
Дата:
Сообщение: Re: [ADMIN] Fast Deletion For Large Tables
Следующее
От: "Johnson, Shaunn"
Дата:
Сообщение: meaning of following errors