Removing Rows in Foreign Keys
От
brew@theMode.com
Тема
Removing Rows in Foreign Keys
Дата
Msg-id
Pine.BSF.4.58.0504040247360.86885@themode.com
Ответ на
Triggers that send emails (Rodolfo J. Paiz)
Список
Дерево обсуждения
Triggers that send emails "Rodolfo J. Paiz" <rpaiz@simpaticus.com>
Removing Rows in Foreign Keys brew@theMode.com
Re: Removing Rows in Foreign Keys Michael Fuhr <mike@fuhr.org>
Re: Removing Rows in Foreign Keys brew@theMode.com
Re: Removing Rows in Foreign Keys Bruno Wolff III <bruno@wolff.to>
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 по дате отправления
