From: | Steven Klassen <sklassen(at)commandprompt(dot)com> |
---|---|
To: | Mike Benoit <ipso(at)snappymail(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PSQL undesired transaction behavior when connection is lost. |
Date: | 2004-10-07 19:33:34 |
Message-ID: | 20041007193334.GA12551@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
* Mike Benoit <ipso(at)snappymail(dot)ca> [2004-10-07 11:47:50 -0700]:
> I assume I'm not the first person to run in to this, however
> searching google didn't seem to come up with anything useful.
AFAICT, the first query is just constructed poorly, while the second
seems to recurse on itself. The order in the sub-selects doesn't seen
necessary either.
> its=> begin; delete from pay_stub_entry where pay_stub_id in (select
> id from pay_stub where created_date >= 1096527603 order by
> created_date desc);
DELETE FROM pay_stub_entry
JOIN pay_stub ON (pay_stub_entry.pay_stub_id = pay_stub.id)
WHERE pay_stub.created_data >=1096527603;
> delete from pay_stub where id in (select id from pay_stub where
> created_date >= 1096527603 order by created_date desc); commit;
DELETE FROM pay_stub WHERE created_data >=1096527603;
--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2004-10-07 19:40:38 | DDL triggers [was Re: database constraints] |
Previous Message | Bruce Momjian | 2004-10-07 18:48:05 | Re: European dates with Win32 version |