Postgres Pro
Downloads
Home   >   mailing lists

Removing Rows in Foreign Keys - Mailing list pgsql-novice

From brew@theMode.com
Subject Removing Rows in Foreign Keys
Date
Msg-id Pine.BSF.4.58.0504040247360.86885@themode.com
Whole thread Raw
In response to Triggers that send emails  ("Rodolfo J. Paiz" <rpaiz@simpaticus.com>)
Responses Re: Removing Rows in Foreign Keys  (Michael Fuhr <mike@fuhr.org>)
Re: Removing Rows in Foreign Keys  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
Tree view 
Well, I confess.  Although I've several databases running on postgreSQL
I've never done more than just store data. (no constaints, no triggers, no
functions, not even any transactions) I'm setting up a new schema for a
new database and am learning about using foreign keys.

Is there a SQL command that removes both a row in a table and the rows in
other tables that reference it or do I have to do it manually?

Sort of like 'DELETE CASCADE....." which I tried, to no avail. Perusing
the manual didn't reveal anything....

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================

pgsql-novice by date:

Previous
From: Aarni Ruuhimäki
Date:
Subject: Re: Database Encoding
Next
From: Michael Fuhr
Date:
Subject: Re: Removing Rows in Foreign Keys