| From: | David Wheeler <david(at)wheeler(dot)net> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, <sfpug(at)postgresql(dot)org> |
| Subject: | Re: Fwd: [Bricolage-Devel] DB Deadlock Detected errors |
| Date: | 2003-07-15 21:39:34 |
| Message-ID: | D3AECF4D-B70C-11D7-99A8-0003931A964A@wheeler.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
On Tuesday, July 15, 2003, at 02:29 PM, Josh Berkus wrote:
> BTW, I've also gotten unnecessary deadlocks when a program I was
> running
> accidentally UPDATED a cartesian product (a join without a
> constraint, so
> all records squared) within an explicit transaction.
>
> So you may want to check your queries as well.
Uh, maybe I'm misunderstanding you, but AFAIK, you can't UPDATE two
tables at once via a join.
In fact, I'm sure I'm misunderstanding you. Can you explain a bit more,
Josh?
Thanks,
David
--
David Wheeler AIM: dwTheory
david(at)kineticode(dot)com ICQ: 15726394
http://kineticode.com/ Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org
Kineticode. Setting knowledge in motion.[sm]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-07-15 22:39:12 | Re: Fwd: [Bricolage-Devel] DB Deadlock Detected errors |
| Previous Message | Josh Berkus | 2003-07-15 21:29:16 | Re: Fwd: [Bricolage-Devel] DB Deadlock Detected errors |