Cascade constraint gone!!!

Поиск
Список
Период
Сортировка
От Linh Luong
Тема Cascade constraint gone!!!
Дата
Msg-id 3B1E5B98.7A694F2@computalog.com
обсуждение исходный текст
Ответы Re: Cascade constraint gone!!!  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
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
Дата:
Сообщение: Re: Tutorial : using foreign keys, retrictions etc
Следующее
От: jmscott@yahoo.com (jmscott@REMOVEMEyahoo.com)
Дата:
Сообщение: maximum number of rows in table - what about oid limits?