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 по дате отправления
От: Roberto Mello
Дата:
От: jmscott@yahoo.com (jmscott@REMOVEMEyahoo.com)
Дата:
FAQ