Re: [GENERAL] one to many

2004-05-16 Thread Dennis Gearon
Stephan Szabo wrote: On Sun, 16 May 2004, Dennis Gearon wrote: CC me please. How do I set up a one to many relationship in Postgres, (any DB for that matter.) I.E., if a delete or update of a child table causes a row in the parent table to no longer refer to any rows in the child table, to eithe

Re: [GENERAL] one to many

2004-05-16 Thread Stephan Szabo
On Sun, 16 May 2004, Dennis Gearon wrote: > CC me please. > > How do I set up a one to many relationship in Postgres, (any DB for that > matter.) > > I.E., if a delete or update of a child table causes a row in the parent > table to no longer refer to any rows in the child table, to either cause >

Re: [GENERAL] one to many

2004-05-16 Thread Peter Eisentraut
Dennis Gearon wrote: > How do I set up a one to many relationship in Postgres, (any DB for > that matter.) Read about foreign keys: http://www.postgresql.org/docs/7.4/static/ddl-constraints.html#DDL-CONSTRAINTS-FK ---(end of broadcast)--- TIP 7: do

Re: [GENERAL] one to many

2004-05-16 Thread Dennis Gearon
Peter Eisentraut wrote: Dennis Gearon wrote: How do I set up a one to many relationship in Postgres, (any DB for that matter.) Read about foreign keys: http://www.postgresql.org/docs/7.4/static/ddl-constraints.html#DDL-CONSTRAINTS-FK That only takes care of if the PARENT is deleted/updat