Received: from aua2.aua.auc.dk (aua2.aua.auc.dk [130.225.54.5]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9QJr9P97329 for ; Fri, 26 Oct 2001 15:53:09 -0400 (EDT) (envelope-from dyrby@nork.auc.dk) Received: from nork.auc.dk (carlsberg.nork.auc.dk [192.38.54.51]) by aua.auc.dk (PMDF V6.0-24 #38884) with SMTP id <01K9Z09ECV8A8WWUWI@aua.auc.dk> for pgsql-sql@postgresql.org; Fri, 26 Oct 2001 21:53:06 +0200 (MET-DST) Received: (qmail 3448 invoked from network); Fri, 26 Oct 2001 19:54:11 +0000 Received: from chilibeer.nork.auc.dk (HELO chilibeer) (192.38.54.145) by carlsberg.nork.auc.dk with SMTP; Fri, 26 Oct 2001 19:54:11 +0000 Date: Fri, 26 Oct 2001 21:55:53 +0200 From: Michael Dyrby Jensen Subject: Deletion Recursively To: pgsql-sql@postgresql.org Message-id: <000a01c15e58$3868a680$6f6f6f6f@nork.auc.dk> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Mailer: Microsoft Outlook Express 5.50.4522.1200 Content-type: multipart/alternative; boundary="----=_NextPart_000_0007_01C15E68.FBC843A0" X-Priority: 3 X-MSMail-priority: Normal X-Archive-Number: 200110/389 X-Sequence-Number: 5341 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C15E68.FBC843A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Greetings. I am fairly new with the postgresql database. And I have run into a problem, which I hope someone can help me with. I am doing a school project, where I have chosen to learn to use this power= ful tool, so I am using it to handle a fictive company of banner advertising. I need to register Advertisers, who got some Campaigns, and these campaigns= have banners. I have an Advertiser table, a campaign table and a banner table. an advertiser hold references to the campaigns that he own, and the campaig= ns have references to the banners that they own. My question is then: "How do I make the Database delete the campaigns and b= anners linked to the advertiser, when I delete him?" A small example would really really help me alot. (with small explanation too ofcause =3D) ) Yours, Michael. ------=_NextPart_000_0007_01C15E68.FBC843A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Greetings.
 
I am fairly new with the postgresql=20 database.
And I have run into a problem, which I hop= e someone=20 can help me with.
 
I am doing a school project, where I have = chosen to=20 learn to use this powerful tool, so I am using it to
handle a fictive company of banner=20 advertising.
 
I need to register Advertisers, who got so= me=20 Campaigns, and these campaigns have banners.
I have an Advertiser table, a campaign tab= le and a=20 banner table.
 
an advertiser hold references to the campa= igns that=20 he own, and the campaigns have references to the banners that they=20 own.
 
My question is then: "How do I make the Da= tabase=20 delete the campaigns and banners linked to the advertiser, when I delete=20 him?"
 
A small example would really really help m= e=20 alot.
(with small explanation too ofcause =3D)= =20 )
 
Yours, Michael.
 
------=_NextPart_000_0007_01C15E68.FBC843A0--