Cascade constraint gone!!! - Mailing list pgsql-sql

From Linh Luong
Subject Cascade constraint gone!!!
Date
Msg-id 3B1E5B98.7A694F2@computalog.com
Whole thread Raw
Responses Re: Cascade constraint gone!!!
List 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 by date:

Previous
From: Roberto Mello
Date:
Subject: Re: Tutorial : using foreign keys, retrictions etc
Next
From: jmscott@yahoo.com (jmscott@REMOVEMEyahoo.com)
Date:
Subject: maximum number of rows in table - what about oid limits?