ad hoc referential integrity
От | Matt Tenenbaum |
---|---|
Тема | ad hoc referential integrity |
Дата | |
Msg-id | 606FC028-B67E-11D7-BFF3-0003939515A2@tty1.org обсуждение исходный текст |
Ответы |
Re: ad hoc referential integrity
|
Список | pgsql-sql |
At the outset I hope that this is the right place to ask this question (also, I hope the question isn't a foolish one). Say I created a couple tables A and B, where A contains a column p which B references as a foreign key. Further say that, when I created these tables, I meant to specify 'on delete cascade' for p in the definition of B but didn't. What's the proper way to ensure both the integrity of the tables and that, when I delete rows from A, the corresponding rows from B are removed as well? (In particular, is there a shorter way than dropping the table and recreating it? Are rules the answer?) Again, I hope this is the right place to answer this question; I guess I'm not 'new' to SQL, but I'm still a bit rough around the edges, so trying to find the answer on my own has been a bit slow-going. Thanks for any help. -matt
В списке pgsql-sql по дате отправления: