possible to DELETE CASCADE?
От | Miles Keaton |
---|---|
Тема | possible to DELETE CASCADE? |
Дата | |
Msg-id | 59b2d39b04123011101872498d@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: possible to DELETE CASCADE?
Re: possible to DELETE CASCADE? Re: possible to DELETE CASCADE? Re: possible to DELETE CASCADE? |
Список | pgsql-general |
Is it possible for a query to delete a record and all of its foreign-key dependents? I see DROP CASCADE, but not a DELETE CASCADE. What I'm trying to do: I have a "clients" table. I have many different tables that use the clients.id as a foreign key. When I delete a client, I want it to delete all records in those many different tables that reference this client. Right now I have my script passing many queries to delete them individually. ("delete from history where client_id=?; delete from payments where client_id=?" -- etc) Any shortcut way to do this?
В списке pgsql-general по дате отправления: