From: Andrew G. Hammond <drew@xyzzy.dhs.org>
To: Andriy Pyrozhenko <andriy.pyrozhenko@vanjaonline.com>
To: pgsql-sql@postgresql.org
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Subject: Re: Question
Date: Sat, 24 Nov 2001 04:39:01 -0500
Message-ID: <E167ZHA-00050B-00@xyzzy.lan.internal> (raw)
In-Reply-To: <1424171808.20011123095513@vanjaonline.com>
References: <GNELIHDDFBOCMGBFGEFOCEINCAAA.chriskl@familyhealth.com.au>
<1424171808.20011123095513@vanjaonline.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 2001 November 23 02:55 am, you wrote:
> >> CKL> ie. ALTER TABLE activities ADD FOREIGN KEY (job_id)
> >> REFERENCES jobs(job_id)
> >> CKL> ON DELETE CASCADE;
>
> CKL> My ALTER TABLE statement above will do exactly this.
>
> CKL> It will delete activities when a job is deleted. Try it in a test
> database.
>
> But also need delete activities!
Which is exactly what this will do. When you ask for help, you might want
to try what people suggest. If you had tried what Chris suggested (twice!)
you would have discovered that his suggestion solves the problem you have
described. Please respect the time and effort of volunteers answering
questions in this forum. You can do this best by devoting some time and
effort to thinking about and learning from the responses posted. At least
try a suggested solution before complaining that it doesn't work!
- --
Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iEUEARECAAYFAjv/aroACgkQCT73CrRXhLEZJACeKGkoYQ65+yMO99rBFiizjSIz
YgcAli4uE+9/e5JkfP8DMqzeXdPMbRQ=
=F89I
-----END PGP SIGNATURE-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: drew@xyzzy.dhs.org, andriy.pyrozhenko@vanjaonline.com, chriskl@familyhealth.com.au
Subject: Re: Question
In-Reply-To: <E167ZHA-00050B-00@xyzzy.lan.internal>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox