Re: DeadLocks..., DeadLocks...
От
Gregory Stark
Тема
Re: DeadLocks..., DeadLocks...
Дата
Msg-id
87r6oevbyq.fsf@oxford.xeocode.com
Ответ на
DeadLocks... ()
Список
Дерево обсуждения
DeadLocks... <tom@tacocat.net>
Re: DeadLocks... Scott Marlowe <smarlowe@g2switchworks.com>
Re: DeadLocks... <tom@tacocat.net>
Re: DeadLocks..., DeadLocks... Gregory Stark <stark@enterprisedb.com>
Re: DeadLocks..., DeadLocks... <tom@tacocat.net>
Re: DeadLocks..., DeadLocks... Bill Moran <wmoran@potentialtech.com>
Re: DeadLocks..., DeadLocks... Gregory Stark <stark@enterprisedb.com>
Re: DeadLocks..., DeadLocks... Alvaro Herrera <alvherre@commandprompt.com>
Re: DeadLocks..., DeadLocks... Tom Allison <tom@tacocat.net>
Re: DeadLocks..., DeadLocks... Gregory Stark <stark@enterprisedb.com>
Re: DeadLocks..., DeadLocks... Tom Allison <tom@tacocat.net>
Re: DeadLocks..., DeadLocks... Gregory Stark <stark@enterprisedb.com>
Re: DeadLocks..., DeadLocks... Tom Allison <tom@tacocat.net>
Re: Intervals (was: DeadLocks..., DeadLocks...) Alban Hertroys <alban@magproductions.nl>
Re: DeadLocks..., DeadLocks... Tom Allison <tom@tacocat.net>
Re: DeadLocks..., DeadLocks... Tom Allison <tom@tacocat.net>
Re: DeadLocks..., DeadLocks... Terry Fielder <terry@ashtonwoodshomes.com>
Re: DeadLocks..., DeadLocks... Tom Allison <tom@tacocat.net>
Re: DeadLocks..., DeadLocks... Alvaro Herrera <alvherre@commandprompt.com>
writes: > But everyone once in a long while it seems that I hit simultaneaous > execute() statements that deadlock on the insertion. What version of Postgres is this and do you have any foreign key constraints or triggers on the table you're inserting into? Is that insert the *only* DML you're executing? No updates or deletes? What do you mean by saying it deadlocks? Do you get a transaction abort with an error about a deadlock detected? Or do you just mean it freezes? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
В списке pgsql-general по дате отправления
От: Frank Wittig
Дата:
