| From: | lars hofhansl <lhofhansl(at)yahoo(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | deadlock using sequences? |
| Date: | 2002-10-05 00:53:17 |
| Message-ID: | 20021005005317.94539.qmail@web40601.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hubert depesz Lubaczewski | 2002-10-05 08:21:36 | Re: Fast Deletion For Large Tables |
| Previous Message | Roland Roberts | 2002-10-04 17:35:31 | Re: [GENERAL] Fast Deletion For Large Tables |