Break referential integrity. - Mailing list pgsql-sql

From Rudi Starcevic
Subject Break referential integrity.
Date
Msg-id 3F0258B6.1040908@oasis.net.au
Whole thread Raw
Responses Re: Break referential integrity.  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Hi,

I know that if you have a trigger and function then drop/replace the 
function the trigger needs
to be drop/replaced too so that it can see the new function.

Is it the same for Ref. Integ. on table's too ?

If table B's foreign key references table A and you drop/replace table A
then the reference from table B to table A is broken and needs to be 
recreated ?

Hope I explained that OK.

Thanks
Rudi.





pgsql-sql by date:

Previous
From: Ang Chin Han
Date:
Subject: Re: LEAST and GREATEST functions?
Next
From: Stephan Szabo
Date:
Subject: Re: Break referential integrity.