Cascade constraint gone!!!
От
Linh Luong
Тема
Cascade constraint gone!!!
Дата
Msg-id
3B1E5B98.7A694F2@computalog.com
Список
Дерево обсуждения
Cascade constraint gone!!! Linh Luong <linh.luong@computalog.com>
Re: Cascade constraint gone!!! Stephan Szabo <sszabo@megazone23.bigpanda.com>
Hi, I recently wipe my database away. And some of the tables have a UPDATE CASCADE on it to another table. When I reload the data from my backup that I did with pg_dumpall. My code started to give me an error because I tried to modify a table that was reference from another table. But the referenced table should have an UPDATE CASCADE. But according to the error it doesn't. Is there a way to add the ON UPDATE CASCADE back without dropping any table again? Thanks -- Linh Luong
В списке pgsql-sql по дате отправления
От: jmscott@yahoo.com (jmscott@REMOVEMEyahoo.com)
Дата: