Re: [SQL] [GENERAL] Foreign Keys Help Delete!

[Stephan Szabo]

On Tue, 19 Sep 2000, Timothy Covell wrote:

> Schema:
>     hosts table with fqhn column
>     routes table with fqhn foreign key hosts(fqhn)
> 
> Problem: 
> 
> 1. When I try to change fqhn in hosts, it complains that
> I have now violated entry in "routes" table.
>
> 2. When I try to update "routes" table, it updates.
> 
> 3. Go back to "hosts" table and now try to rename/delete
> old fqhn and it complains about object missing with OID=xxxxx.

Can you give the table structure and statements you were
doing specifically?