Delete Cascade

Поиск
Список
Период
Сортировка
От Marcelo Pereira
Тема Delete Cascade
Дата
Msg-id 00a201c0ab06$20031400$0b01a8c0@hmmg
обсуждение исходный текст
Ответы Re: Delete Cascade  (Karel Zak <zakkr@zf.jcu.cz>)
Re: Delete Cascade  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Дерево обсуждения
Hi,
 
I am in trouble deleting rows in cascade.
 
I have a scheme like this:
 
create table author (author_cod integer primary key, author_name char(20));
create table book (book_cod integer primary key, book_autor integer references author(author_cod), book_title char(30));
 
I would like to delete a 'author' in the author table and also all your books in the book table.
 
When I run
 
delete from author where author_cod = <number>
 
I dont get the row deleted if there is a row referenced by in the book table.
How can I delete my rows in cascade ???
 
Thanks in advance,
 
Marcelo Pereira
Computer Programmer

В списке pgsql-general по дате отправления:

Предыдущее
От: martin.chantler@convergys.com
Дата:
Сообщение: Re: Re: Anyone can create tables!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Poor Delete performance