Break referential integrity.

From: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Break referential integrity.
Date: 2003-07-02 03:59:50
Message-ID: 3F0258B6.1040908@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ang Chin Han 2003-07-02 04:02:10 Re: LEAST and GREATEST functions?
Previous Message Jonathan Man 2003-07-02 03:17:22 Timeout for lock table