Re: [GENERAL] Foreign Keys Help Delete! - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: [GENERAL] Foreign Keys Help Delete!
Date
Msg-id Pine.BSF.4.10.10009191732080.54561-100000@megazone23.bigpanda.com
Whole thread Raw
In response to [GENERAL] Foreign Keys Help Delete!  (Timothy Covell <dirac@applink.net>)
List pgsql-sql
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?


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [GENERAL] Foreign Keys Help Delete!
Next
From: Jie Liang
Date:
Subject: Re: [GENERAL] Foreign Keys Help Delete!