Postgres Pro
Downloads
Home   >   mailing lists

Creating related tables - Mailing list pgsql-novice

From Ângelo Marcos Rigo
Subject Creating related tables
Date
Msg-id 20051019123420.65330.qmail@web34413.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Creating related tables  (Michael Glaesemann <grzm@myrealbox.com>)
Re: Creating related tables  ("Kevin Crenshaw" <kcrenshaw@viscient.com>)
Re: Creating related tables  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-novice
Tree view 
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@yahoo.com.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/

pgsql-novice by date:

Previous
From: Mogin Mohandas
Date:
Subject: bit map indexes in postgres
Next
From: Michael Glaesemann
Date:
Subject: Re: Creating related tables