Re: Delete with join -- deleting related table entries?

From: "Owen Jacobson" <ojacobson(at)osl(dot)com>
To: "Owen Jacobson" <ojacobson(at)osl(dot)com>, "Bryce Nesbitt" <bryce1(at)obviously(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Delete with join -- deleting related table entries?
Date: 2006-02-08 17:35:14
Message-ID: 144D12D7DD4EC04F99241498BB4EEDCC20CC5A@nelson.osl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Owen Jacobson wrote:

> BEGIN;
> DELETE FROM note WHERE issue_id IN (SELECT issue_id FROM isuse
> WHERE reservation_id = reservation_to_delete);
> DELETE FROM isuse WHERE reservation_id = reservation_to_delete;
> DELETE FROM reservations WHERE reservation_id =
> reservation_to_delete;
> END;

That should be COMMIT;, not END;. Been writing too much pl/pgsql.
-Owen

Browse pgsql-sql by date

  From Date Subject
Next Message BigSmoke 2006-02-08 17:36:36 Re: regarding debugging?
Previous Message Bryce Nesbitt 2006-02-08 17:33:22 Re: Delete with join -- deleting related table entries?