| From: | Ângelo Marcos Rigo <angelo_rigo(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Creating related tables |
| Date: | 2005-10-19 12:34:20 |
| Message-ID: | 20051019123420.65330.qmail@web34413.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi
I need to create 1:N related tables .
eg.: table A and a table B.
- table B will have motorcicles
- table A will have motorcicles owners
If a owner is deleted from the table A i need to
delete all the motorcicles with the deleted owner id
in the B table.
What is the sintax in postgesql todo this ?
Ângelo Marcos Rigo
AMR Informática
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo(at)yahoo(dot)com(dot)br
_______________________________________________________
Promoção Yahoo! Acesso Grátis: a cada hora navegada você acumula cupons e concorre a mais de 500 prêmios! Participe! http://yahoo.fbiz.com.br/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2005-10-19 13:06:49 | Re: Creating related tables |
| Previous Message | Mogin Mohandas | 2005-10-19 02:26:54 | bit map indexes in postgres |